how can i extract the right most characters of a text after a seperator
suppose i have "asdf-12df-654" in cell B5 and "df-5d7-df7854" in Cell B6 and
so on downwards. i want to extract the right most characters which are 654 in
cell B5 and df7854 in B6. how can i do this by using function (not VBE)

thanks

if your strings are in a25 and b25 respectively
=RIGHT(SUBSTITUTE(A25,"-","&",2),LEN(SUBSTITUTE(A25,"-","&",2))-SEARCH("&",SUBSTITUTE(A25,"-","&",2),1))
same for the other one but replace a25 with b 25.This assumes there will
always be two dashes within the number and any number of other letters and
numbers...
The logic here is first i replace the second dash with a & then find out
where the & is in the string then i can count the characters to the right of
the & to use the right function.....
--
paul
remove nospam for email addy!



"Starguy" wrote:

how can i extract the right most characters of a text after a seperator
suppose i have "asdf-12df-654" in cell B5 and "df-5d7-df7854" in Cell B6 and
so on downwards. i want to extract the right most characters which are 654 in
cell B5 and df7854 in B6. how can i do this by using function (not VBE)

thanks