One way:

=LOOKUP(2,1/(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)="e"),
ROW(INDIRECT("1:"&LEN(A1))))

Change "e" to the last character you want to find.

Lee Hunter wrote:

Thanks you gentlemen. I'm sorry that I asked the wrong question. I actually
need to search from the end of the string and need the InStrRev function.
Possible without code?

Lee

"Dave Peterson" wrote:

You can use =search() or =find()

=if(isnumber(search("something",a1)),"found it","nope")

=find() is case sensitive
=search() isn't.

Lee Hunter wrote:

Is there anyway to use the InStr function in a formula or must I create a VBA
function to do it?

Thanks,
Lee

--

Dave Peterson


--

Dave Peterson