thanks, both to Tom and Bob.

Another way I've just found is to create a VBA user function in a module
(best in personal.xls so it's always available):

Function myReverse(stringtocheck As String, stringtomatch As String, startas
As Long)
myReverse = InStrRev(stringtocheck, stringtomatch, startas)
End Function


"Tom Ogilvy" wrote:

> =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" <Martin@discussions.microsoft.com> wrote in message
> news:4445F4DE-5C3C-4F66-B5AF-6D18D440D736@microsoft.com...
> > 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!
>
>
>