View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Visual Calendar Dilemma Visual Calendar Dilemma is offline
external usenet poster
 
Posts: 9
Default 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?