Sorry about the first thread, hit enter accidentally

I have a data column that has names in it, exaple

Johnni
Fred Jackso
Alfred Michael Smit

Need a macro if one can be possible to endu

Johnni
Fred Jackso
Alfred Michael Smit

Thank all so very much for any help on this

floss