Excel - convert row address listing to columnar database

Giganews Newsgroups
Subject: Excel - convert row address listing to columnar database
Posted by:  Thumbpick
Date: Sat, 20 May 2006

I have a mailing list of addresses in rows (mostly 3 rows), e.g.,
Mr. & Mrs. Anthony Strebek
8205 Dorset Lane
Springfield, MO  33345-1234

But some are 4 rows:
Mr. & Mrs. Albert Stratton
7789 Quonset Drive
Apt. 203
Portland, ME  22152

I want to convert it to a database, e.g.,
Streber,Anthony,8205,Dorset,Lane,Springfield,MO,33345

Is there a macro or formula to make this easier than retyping everything?

Thanks!

Replies