worksheet function for InStrRev()
Here is one way
=MAX(IF(MID(A10,ROW(INDIRECT("1:"&LEN(A10))),1)="~ ",ROW(INDIRECT("1:"&LEN(A1
0)))))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"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!
|