Copy, paste special-transpose (now in columns). Data - Text to columns.
Copy, paste special- transpose back to rows.

--
Best Regards,

Luke M
"nyarce" wrote in message
...
I know how to split cell contents to columns, but how do you tell excel to
take the cell contents and insert into new rows. Each name is separated
by a
comma and I need each name to appear in its own row beneath that cell.
PLEASE HELP!