| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete commas and spaces when not needed ... S&R way, or macro way?
Yes, I did... sorry.
-- Rick (MVP - Excel) "Jim Cone" wrote in message ... Rick, I think you missed my original post Jim Cone "Rick Rothstein" wrote in message I know he asked about leading/trailing spaces, but his original question showed there were commas in front of the spaces that also had to be removed. In addition, your suggestion would change the text he wants to preserve if it happens to have multiple internal spaces (for formatting or column alignment as an example) since TRIM collapses multiple spaces down to single spaces. -- Rick (MVP - Excel) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save as CSV: extra spaces around commas | Excel Discussion (Misc queries) | |||
| macro to delete spaces doesn't compile | Excel Programming | |||
| How Do I Add Commas To Columns And Remove Spaces In Excel?? | Excel Discussion (Misc queries) | |||
| Macro needed to delete rows | Excel Programming | |||
| parsing text field based on commas or spaces | Excel Programming | |||
Threaded Mode
