Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Mailing Address to multiple cells
I have been provided with a few thousand mailing addresses. Each address is
written into a single cell, i.e. 123 Fair St. Orlando FL 12345, instead of 123 Fair St. / Orlando / FL / 12345. I need to break out the addresses into separate columns by Street / City / State / Zip. I am familiar with the text to columns function, but the addresses are not consistent enough to make this straight forward. Any help is greatly appreciated. Thank You, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a address book for mailing labels | New Users to Excel | |||
address data base in which I can choose which to use for mailing | New Users to Excel | |||
How do I put two names on a mailing list at the same address witho | Excel Discussion (Misc queries) | |||
How do I put two names on a mailing list at the same address witho | Excel Discussion (Misc queries) | |||
Extract comma broken address to cells | Excel Discussion (Misc queries) |