Thread: Find Function
View Single Post
  #2   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

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