Thread: How can I copy characters from a cell that follow a hypen
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default How can I copy characters from a cell that follow a hypen
Try this:

=MID(A1,FIND("-",A1)+1,3)

HTH,
Elkar


"brantty" wrote:

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