Thread: How can I copy characters from a cell that follow a hypen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brantty brantty is offline
external usenet poster
  
Posts: 16
Default How can I copy characters from a cell that follow a hypen
I have a cell that has data followed by a hyphen then more data.
EX 12345-ABC456123-more data

I want to copy the first three characters that follow the hyphen so my cell
looks like:

EX ABC

What formula will look to the original cell and remove all the info but keep
the three characters I need?
Reply With QuoteReply With Quote