>>Thanks for the help. Your solution was a great start. It looks like about 90% of the problem is solved by your code. The other 10% will require the users to fix by hand (so to speak).
>
>* Glad to hear it! Another solution that you may not have heard is a bit simpler, assuming your "mess" has a Zip. Scan the string and just pick up the zip code, then you should automatically know the city and state, you could use a commercial ZIP code database (I know Josh Assing sells a very complete one) to get the answers you need.


Mike,

You are right that you can get state from zip code.
Unfortunatelly it's not true for city because more than one city could have the same zip code.