View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ty ty is offline
external usenet poster
 
Posts: 19
Default Remove data that preceeds a character

I have a a column of data that has 4 seperate hyphens in the text.
EX. abc-123-abc-123-BEGIN NEEDED DATA AND THIS DATA ALSO HAS HYPHENS I WANT
TO KEEP.

How can I remove all the data that preceeds the 4th and final hyphen and
keep the needed data. The # of characters in the preceeding data varies, so
the 4th hyphen ( from the left) is the only consistent measure I have.

--
Thanks, Ty