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,33 345

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

Thanks!