View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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