| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Problems in Comma Separated List
Hello,
I have a comma separated list with codes that is set up as G01, G02, G03, H01, Y02, B03, A06. There can be many many codes on each row, but they should only be separated by commas and spaces but no other characters. Is there a function I can use to show any unnecessary spaces and characters? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turning column contents into text list separated by a comma | Excel Discussion (Misc queries) | |||
| How can I extract the first & last name separated by a comma | Excel Discussion (Misc queries) | |||
| combine rows into one cell separated by comma | Excel Discussion (Misc queries) | |||
| Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
| Going from column to comma separated list... | Excel Discussion (Misc queries) | |||
Threaded Mode
