As long as there are letters in the sequences,
Select all the cells or an area that contains all the cells but not hyphens
you do not want to delete.
then do Edit=Replace
Replace What: =
Replace With: ' leave blank
Then click OK
--
Regards,
Tom Ogilvy
rmaloy wrote in message
...
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!
---
Message posted from http://www.ExcelForum.com/