Reformatting addresses in excel 2003

B

bob_mhc

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
(e-mail address removed)
 
H

Harlan Grove

bob_mhc said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top