extracting strings and numbers from one cell into seperate cells??

Hi,
I need to separate the content of every address cell to the four separate cells : city, street, street number, zip code

address cell examples:
98 ironwood street rochester 48063
chesterfield 55 street , Chicago 55660
76 drexler , Bozman , 33087
Collins 230, Austin
etc
etc

I have a comprehensive city list available:
Bozeman
Chicago
Austin
rochester
springfield
Los Angeles
etc

order and location of numbers and texts in address cells is not fixed : 98 ironwood or ironwood 98, city name may appear first etc:
98 ironwood rochester 48063
rochester 48063 ironwood 98

zip code is always 5 digit number
street number is 3 digit or less
Can anyone please point me in the right direction?
I atached an excel sheet with the problem.
Thanks,
Ziv