it would have been easier to re-state it Ron :-)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
Look at the answer in your first thread

--
Regards Ron de Bruin
http://www.rondebruin.nl


"floss" wrote in message
...
Sorry about the first thread, hit enter accidentally.

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

Johnnie
Fred Jackson
Alfred Michael Smith

Need a macro if one can be possible to endup

Johnnie
Fred Jackson
Alfred Michael Smith

Thank all so very much for any help on this.

floss