Nancy Smith, Joe Pelegro, Janie Simmons are all in one cell. I need excel to
create a new row below Nancy Smith and insert Joe Pelegro in there by himself
and the same for Janie Simmons so that it looks like:

Nancy Smith
Joe Pelegro
Janie Simmons

I also need to make sure the new rows to not overwrite/delete the contents
of the existing rows beneath the original entry of Nancy Smith, Joe Pelegro,
Janie Simmons, hence me needing excel not only to move these contents but
create new row for each name.

"dlw" wrote:

you need to use text functions like FIND, MID, LEFT, RIGHT to chop up the
cell, tell us what the data looks like and we can give specific examples.

"nyarce" wrote:

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!