View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
starguy
 
Posts: n/a
Default Extracting using seperators


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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=526267