Separate an alphanumeric cell into its components

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?
Thanks,
Ziv

Originally Posted by martindwilson

lots of manual copy paste would be required unles you have something seperating fieldsfor example is there always a ,(comma) between items?

there are usually no commas, just text and numbers. I suppose I could use a function to delete all commas to make it uniform.
city name is one of a finite list of cities I have within the spreadsheet (perhaps 200 or so). Street name is any other text in the cell (no state or country in the cell). any 5 igit number is zip code. Any 3 or less digit number is street number.

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

see attached spreadsheet

Thanks