| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert row address listing to columnar database
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| How do I use Excel to post data to an external database? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| PLEASE HELP!? Creating a simple database with excel, minor setback | Excel Worksheet Functions | |||
Threaded Mode
