Download the free add-in Asap Utilities. They have a great Advanced transposer
that you basically highlight the area of data, tell it how many columns and it
does it's job

www.asap-utilities.com



"Nickornyk" wrote in message
...
: I copied address off the internet. They are all isted in column A.
:
: example:
: First Place Awards
: 1234 Fifth Avenue
: New York, NY 11111
:
: How do I get row 2 to column b and row 3 to column c?
:
: What I want.
: A B C
: First Place Awards 1234 Fifth Avenue New York, NY 11111
:
: I have 10,000 address all in this one column that I'd like to have seperated
: into 3 columns. I don't have the time to cut and paste.
:
: Any way I can do this?