worksheet function for InStrRev()
=FIND("~",SUBSTITUTE(D6,"the","~",(LEN(D6)-LEN(SUBSTITUTE(D6,"the","")))/LEN
("the")))
Entered with Ctrl+Shift+Enter since it is an array formula.
Searches for the last occurance of "the" as an example.
--
Regards,
Tom Ogilvy
"Martin" wrote in message
...
Is there such a thing? I know there's SEARCH() which is equivalent to
InStr() in VBA but now we have InStrRev() which searches for a string from
the end rather than the beginning. Be a lot more useful than CRITBINOM()
etc!
|