Nickornyk wrote:
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?
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, and if the
addresses are always 3lines, no gaps between them

=ArrayReshape(a1:a30000,10000,3) array entered into B1:D10000

Alan Beban