| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a space after a comma
I have a string of text with commas and no spaces.
Example: Sales,Planning,Systems What function do I use to insert a space after each comma? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting a space after a comma
hi
Edit | Replace "," to ", " (no quotes) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Visual Calendar Dilemma" escreveu: I have a string of text with commas and no spaces. Example: Sales,Planning,Systems What function do I use to insert a space after each comma? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Inserting a space after a comma
That was just way too simple... :-)
thank you!! "Marcelo" wrote: hi Edit | Replace "," to ", " (no quotes) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Visual Calendar Dilemma" escreveu: I have a string of text with commas and no spaces. Example: Sales,Planning,Systems What function do I use to insert a space after each comma? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting a space in a number | Excel Worksheet Functions | |||
| how to format Doe,John to Doe, John (space after a comma) | Excel Worksheet Functions | |||
| Removing a space after a comma | New Users to Excel | |||
| Inserting a Space in The Same Place Formula | Excel Worksheet Functions | |||
| HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) | |||
Linear Mode
