View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dsimcox dsimcox is offline
external usenet poster
 
Posts: 18
Default Why doesn't INSTREV work for me?

I'm using INSTREV to retrieve the location of a character in a string by
searching from the end of the string.

When I type the following in the immediate window:

?InStrRev("1234567-89", "-")

I get an answer of 8.

I was expecting 3. (The position of the "-" is 3 characters from the
right-hand side of the string)

Am I interpreting this incorrectly?