If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP! Split cell contents to new rows
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! |
#2
|
|||
|
|||
HELP! Split cell contents to new rows
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! |
#3
|
|||
|
|||
HELP! Split cell contents to new rows
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! |
#4
|
|||
|
|||
HELP! Split cell contents to new rows
Hi,
Highlight the column, text to column, delimited,check the box that says comma, finish "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! |
#5
|
|||
|
|||
HELP! Split cell contents to new rows
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! |
Thread Tools | |
Display Modes | |
|
|