Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent deleting multiple cells at once | Excel Discussion (Misc queries) | |||
Deleting some content of a cell | Excel Discussion (Misc queries) | |||
Deleting content | Excel Worksheet Functions | |||
Deleting content in a column | Excel Worksheet Functions | |||
Deleting content in a column | Excel Worksheet Functions |