ExcelBanter - Inserting a space after a comma

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Inserting a space after a comma (https://www.excelbanter.com/excel-worksheet-functions/109454-inserting-space-after-comma.html)

Visual Calendar Dilemma

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?

Marcelo

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?

Visual Calendar Dilemma

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?

All times are GMT +1. The time now is 04:07 PM.