I have an address list that has all info in one column -
1234 Spring St New Pottstown AZ 80752
5478 Gallant Forest Ave Apt 432 Media PA 19237

I can't use find (" ") because some of the street names are 1 name, some are 2.
Some of the cities are 2 words, some are 1.
The formatting is not consistent.
There are no delimiters.

How can I get the street address info separated out by 4 columns -- street address, city, state, zip ?

Thank you.