Spacing formula

[Noah101]

Sorry guys, I've done this before but cant get it to work this time

I have a name as such John,Doe but I need an extra space after the comma as such John, Doe

Please assist

 

[Joe4]

Just do a Find/Replace, replacing the comma with a comma and a space.

 

[Noah101]

Thanks Joe!

However I was looking for something more automated as I don't want to keep doing this all the time, so I solved it my self it's
=Replace, I needed this in a helper column.

However thank you for your suggestion.

Noah

 

[Joe4]

OK. I am not sure how adding a formula is more automated than doing a Find/Replace (you can do a Replace All to do them all at one time).
If you truly want something automated, VBA would be the way to go. You could turn on the Macro Recorder and record yourself doing the Find/Replace All, and you would then have the code for that.
Then, you could easily replace them all with a single click (if you attach the macro to a button), or a keyboard shortcut, without having to use any helper columns.