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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert row address listing to columnar database
You want every space and "end-of-line" replaced with a comma?
-- Regards, Tom Ogivy "Thumbpick" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - convert row address listing to columnar database
No…. sorry, poor example on my part. What I really need to do is convert a row format addr listing to a flat file, parsed addr listing (i.e., one row); e.g., From: John Doe Blast, Inc. 123 maple Ave Philadelphia, PA 19026-2234 To: A1 B1 C1 D1 E1 F1 G1 H1 I1 Doe John Blast Inc 123 Maple Ave Philadelphia PA 19024-2234 As I said, some are 3 line, some are 4. Also, I’ve inherited a poorly designed addr listing… sometimes the 2nd row is an addr, sometimes the street addr (in which case the st addr is 3rd line). However, none is more that 4 rows. Each record is separated by a blank row. -- elgeejay ------------------------------------------------------------------------ elgeejay's Profile: http://www.excelforum.com/member.php...o&userid=34627 View this thread: http://www.excelforum.com/showthread...hreadid=543984 |
Reply |
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 |