Prev: Sorting by number of characters
Next: Need to print the second sheet only if it is active
From: nyarce on 13 May 2010 12:58
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!
From: Luke M on 13 May 2010 13:12
Copy, paste special-transpose (now in columns). Data - Text to columns.
Copy, paste special- transpose back to rows.

--
Best Regards,

Luke M
"nyarce" <nyarce(a)discussions.microsoft.com> wrote in message
news:E9E6CDF2-7A05-4337-B0DD-C88FCFF617B4(a)microsoft.com...
>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!


From: dlw on 13 May 2010 13:14
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!
From: Eduardo on 13 May 2010 13:34
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!
From: nyarce on 13 May 2010 13:45
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!
 | 
Pages: 1
Prev: Sorting by number of characters
Next: Need to print the second sheet only if it is active