Coma betwwen two First name and last name in column B macro

[sunnyp]

I need a macro that put coma in between names in column B

 

[Hui]

Sunnyp


Do you need a Macro or a Formula?


In an adjacent column

You can use a simple =SUBSTITUTE(B2," ",", ")

Copy the new data /Paste Values

Then delete the original data

 

[Hui]

If you really do need some VBA code the following will do it:

[pre]

Dim c As Range
For Each c In Range("B2", Range("B65536").End(xlUp))
c.Value = Replace(c.Value, " ", ", ")
Next

[/pre]