View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KingGeezer
 
Posts: n/a
Default finding rightmost location of a character

I have a text string (a directory path actually) that has several "/"
characters in it.
I'd like to find the location of the right-most occurrance of an "/".
For example, if the string was: "mama/poppa/bogus/dog" .... how do I find
the position number of the "/" right before 'dog'?
Thanks for any help you can provide!