Inserting a space after a comma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
hi

Edit | Replace

"," to ", " (no quotes)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Visual Calendar Dilemma" escreveu:
 
hi

Edit | Replace

"," to ", " (no quotes)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Visual Calendar Dilemma" escreveu:
 
That was just way too simple... :-)

thank you!!

Marcelo said:
hi

Edit | Replace

"," to ", " (no quotes)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Visual Calendar Dilemma" escreveu:
Click to expand...
 
That was just way too simple... :-)

thank you!!

Marcelo said:
hi

Edit | Replace

"," to ", " (no quotes)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Visual Calendar Dilemma" escreveu:
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Problems in Comma Separated List 5
removing commas from numbers etc. 2
Histogram/Frecuency for Multiple Response Questions 1
Nees Function to Split 3
Data cleanup 1
Search for number after specific text in string 8
Help with blank cells when concatenating 11
How to extract separated text by many commas in Excel? 0

Back
Top