Showing posts with label string functions excel. Show all posts
Showing posts with label string functions excel. Show all posts

Tuesday, 21 July 2015

Search From right side in Excel VBA

Use the  function InStrRev(String searched, String Sought, Start, CompareMethod)

InstrRev(one_two_three,"_") should return 8, so the search is from the right, But the position is returned from the left.