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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Mailing Address to multiple cells
On Mon, 3 Nov 2008 07:36:00 -0800, Eric wrote:
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, It can be done using formulas, but the difficult part will be the break between the street address and the city. It would be simple if all the cities in your list are a single word. But that would be unusual. Do you have a list of city names we could use? Here is the general algorithm: Zip code: last "word" in the string, all digits with an optional "-" State: 2 letter word preceding zip code Street address beginning of string to start of City City: look up from list --ron |
Reply |
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) |