View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Deleting Hyphens or Dashes from multiple cells without deleting the remaining content

Just for interest.
In the US menu structure it is just Edit=Replace

--
Regards,
Tom Ogilvy


Frank Kabel wrote in message
...
Hi
try 'Search and Replace' from the Edit menu

Frank

I have a column in excel that has a list of circuit id's. All of

these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of
the hyphens/dashes, without having to go into each cell individually?
I still need the characters to remain in order, just without the
hyphens. (Ex. 1344M1210001, 1344M12100001)

Thanks!