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!
|