Oops, I mis-read, this just newlines them.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
=SUBSTITUTE(A21,",",CHAR(10))

but you will still need to manually add wrap text to the cell and adjust
its
height

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hardip" wrote in message
...
Hi All,

I have a list of names like so:

John Thomson, Paul Cooper, Ian Smith, Mark Devlin... and so on

The names are in one continuous string i.e. they start from one cell
(A1).

I'd like to replace the commas with a carriage return to place each name
into its own cell. Is there function or calculation I can use to
achieve
this?

Any advise would be appreciated.

TIA - H