How to Make a space after a comma

Question

Hi,

I have a list of names and some of them may not be formatted correctly, so I need to be able to add a space after the comma. I am trying to do this with two formulas:

ReplaceChar([Name],","," ")

ReplaceChar([Name]," ",", ")

but what I am getting is a double comma between the last a first name.

Smith,Jennifer

Smith, Jennifer

Becomes:

Smith,,Jennifer

thanks!

jenner85 · Accepted Answer

Ok, I know what I did wrong - I should use replace string not char.

Emil_Kos · Accepted Answer

Hi @jenner85,

Replace function will work better for you:

Replace([Name], ',', ', ')

Emil_Kos · Accepted Answer

Hi @jenner85,

Please check if this works for you: