Equivalent of InStr and InStrRev in excel

[TheBuGz]

How to use the following VBA functions

InStr
InstrRev


In excel

 

[NewOrderFac33]

Rick, yes, this works, thank you.
I also found some variations of my own, if you'd be interested in trying them out:

Case Sensitive
=IF(ISERROR(FIND(D73,B73)),"-",FIND(D73,B73))

Case Insensitive using UPPER
=IF(ISERROR(FIND(UPPER(D74),UPPER($B$70))),"-",FIND(UPPER(D74),UPPER($B$70)))

Case Insensitive replacing FIND with SEARCH
=IF(ISERROR(SEARCH(D75,B75)),"-",SEARCH(D75,B75))

In all cases, column B is the string being searched and column D is the string being searched FOR.

Cheers

Pete

 

[RoryA]

That works as Instr not InstrRev though. For the latter you can also use this non-array-entered version:
=LOOKUP(1E+100,SEARCH(A1,MID(B1,ROW(INDIRECT("1:"&LEN(B1))),LEN(A1))),ROW(INDIRECT("1:"&LEN(B1))))

 

[Rick Rothstein]

That works as Instr not InstrRev though. For the latter you can also use this non-array-entered version:
=LOOKUP(1E+100,SEARCH(A1,MID(B1,ROW(INDIRECT("1:"&LEN(B1))),LEN(A1))),ROW(INDIRECT("1:"&LEN(B1))))

I would note that your formula is Volatile... I believe this modification to it would make it non-Volatile and yet still keep it working...

=LOOKUP(1E+100,SEARCH(A1,MID(B1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(B1))),LEN(A1))),ROW(INDEX(A:A,1):INDEX(A:A,LEN(B1))))

 

[RoryA]

True - but if I had a lot of those, I'd rethink my workbook!