Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing spaces with underscore for specific expressions
Dear Experts:
I got numbers in column C with the following Synthax (xxxxSpacexxx), e.g. 0250 434 or 0748 314 All these expressions are located in Column C and the 'Space' should be replaced with an 'Underscore'. After the replacement the expressions should look like this: 0250_434 or 0748_314 Please note: There are other expressions in cells of column C, such as 192344 / 134374. But those spaces should not be replaced with the underscore character. I would like to run a macro for this problem. Thank you very much in advance for your professional help. Regards, Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
underscore in email address covered by hyperlink underscore | Excel Discussion (Misc queries) | |||
Replacing spaces with a line end | Excel Discussion (Misc queries) | |||
Replacing spaces with zeros | Excel Programming | |||
Replacing specific characters with spaces | Excel Worksheet Functions | |||
replacing spaces? | Excel Programming |