Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
parsing out an undelimited address and city
I am trying to write programing to parse out a data file to seperate
the address and the city. Examples below: 1149 N CARRIER PKY APT A44 GARDEN PRAIRIE 306 ROYALTY AVE WALHALLA 40 DANAS CT APT 1 WESTBRIDE 4139 W HAVEN AVE MORTON The results I want are below: Address City 1149 N CARRIER PKY APT A44 GARDEN PRAIRIE 306 ROYALTY AVE WALHALLA 40 DANAS CT APT 1 WESTBRIDE 4139 W HAVEN AVE MORTON I have tried text to columns with delimited by spaces, but the problem is you don't know how many spaces there are? Any help? Thanks KTG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I manipulate a string to collect the address from it? | Excel Discussion (Misc queries) | |||
Splitting comma separated lines of an address for mail merge. | Excel Discussion (Misc queries) | |||
Excel Address Lists | Excel Discussion (Misc queries) | |||
Split Address Correction | New Users to Excel | |||
Address labels to columns | Excel Discussion (Misc queries) |