On Sat, 13 Jun 2009 21:13:17 GMT, Lars-Åke Aspelin
wrote:

On Sat, 13 Jun 2009 12:04:01 -0700, Lin400
wrote:

I have almost 800 rows of alpha titles in one column I want to split into two
columns, while keeping them in alphabetical order - side-by-side rather than
one long alpha list.

Is this poss without spending hours moving each line manually?

V. Excel 2003


If your data are in cells A1:A800, try this:

In cell B1 you enter the following

=OFFSET(A1,2*ROW()-2,0)

In cell C1 you enter the following

=OFFSET(A1,2*ROW()-1,0)

Then copy cells B1:C1 down as long as needed (to B400:C400 if you have
800 data)

Finally copy cells B1:C400 and paste them with
"Paste Special / Values" to where you want your two new columns to be.

Hope this helps / Lars-Åke

Sorry, replace A1 with A$1 in the two formulas above.