Brute force :-):
=RIGHT(A2,LEN(A2)-FIND("/",SUBSTITUTE(A2,"-","/",LEN(A2)-LEN(SUBSTITUTE(A2,"
-",""))-1)))
--
Vasant
"Steve" wrote in message
...
Hi
Cell A2=aaaa-bbb-cccc-d
in A1 I would like a formula to find the second "-" from the right and
return cccc-d. The number of characters in each segement of A2 can vary
and
thennumber of segments may vary as well, so the search will have to be
from
the right.
Thanks
|