Reformatting addresses in excel 2003
 

I have a list of many addresses in a spreadsheet - all in column A -- each
address taking 3 cells of column A:

Grace Cushman
12 E. Mt. Vernon Place
Baltimore, MD 21204
William Harris
2345 34th St.
Boston, MA 02123
etc...

I want to put these in rows and 3 columns (A, B, and C):

Grace Cushman | 12 E. Mt. Vernon Place | Baltimore, MD 21204
William Harris | 2345 34th St | Boston, MA 02123
etc...

Any suggestions?
Thanks,
Bob

Reformatting addresses in excel 2003
 

bob_mhc wrote...
I have a list of many addresses in a spreadsheet - all in column A -- each
address taking 3 cells of column A:

Grace Cushman
12 E. Mt. Vernon Place
Baltimore, MD 21204
William Harris
2345 34th St.
Boston, MA 02123
etc...

I want to put these in rows and 3 columns (A, B, and C):

Grace Cushman | 12 E. Mt. Vernon Place | Baltimore, MD 21204
William Harris | 2345 34th St | Boston, MA 02123
etc...
....

If every record spans exactly 3 rows, if the original table of such
records were in a single-column range named D, and if the topmost
result record would be in A2:C2, try these formulas.

A2:
=INDEX(D,3*(ROWS($A$2:$A2)-1)+COLUMNS($A$2:A$2))

Fill A2 right into B2:C2, then select A2:C2 and fill down as far as
needed.

Reformatting addresses in excel 2003
 

Thanks, Harlan,

That was enormously helpful!

Bob