Thread: How to remove characters in a cell that precede a specific hyphen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brantty brantty is offline
external usenet poster
  
Posts: 16
Default How to remove characters in a cell that precede a specific hyphen
I have a column of cells that have excess data that needs removed. The #of
characters vary. I'm needing a formula to delete all the characters that
precede the 2nd hyphen as well as delete the 2nd hyphen.

Ex. [ABC-12345-12345]

I need the cell to read [12345]

Can anyone provide a formula that can remove this data?

Reply With QuoteReply With Quote