Thread
:
parsing out an undelimited address and city
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
parsing out an undelimited address and city
With all the variation of addresses, the only reliable way that I know is to do
it manually.
Good luck.
wrote:
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
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson