Excel function for reverse string searching?

[megmoo75]

Does anyone know if there's an Excel function for searching for a particular character starting on the right side of the string, rather than the left.

I basically just want the SEARCH function to start at the end of a string and search backwards.

Thanks in advance.

 

[xlbo]

You be looking for InStr & InStrRev

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[megmoo75]

Worked perfectly - thanks!