Moving columns into rows

I'm constantly getting e-mails at work that require me to make a spreadsheet
of the names the e-mail was sent to.

The text looks something like this (and it's all in one cell) after I paste
it into Excel (I'm using 2002 SP3 on Windows XP Pro).

LastName, Firstname; LastName2, FirstName2; LastName 3, FirstName3; etc.

I know how to break the names up by semicolons using the "Text to Column"
feature, but how do I make the names that are then in 20 or more columns into
rows?

I would like the finished product to look like this:

LastName, Firstname
LastName2, FirstName2
LastName 3, FirstName3
etc.

Any ideas on doing this without a macro?

Thanks,

Jim

Jim

copy the cells and then use Paste Special | Transpose to copy them to
another area on the spreadsheet.

Regards

Trevor


"jim314" wrote in message
...
I'm constantly getting e-mails at work that require me to make a
spreadsheet
of the names the e-mail was sent to.

The text looks something like this (and it's all in one cell) after I
paste
it into Excel (I'm using 2002 SP3 on Windows XP Pro).

LastName, Firstname; LastName2, FirstName2; LastName 3, FirstName3; etc.

I know how to break the names up by semicolons using the "Text to Column"
feature, but how do I make the names that are then in 20 or more columns
into
rows?

I would like the finished product to look like this:

LastName, Firstname
LastName2, FirstName2
LastName 3, FirstName3
etc.

Any ideas on doing this without a macro?

Thanks,

Jim