hi there. it's always good to upload a few eg in an excel file & show us your desired results. if you could, share with us some patterns you know because not all of us are familiar with your City, State & Zip. from what i assume; City before comma, State before the space of the number, & last series of numbers are the Zip. so maybe:
=LEFT(A1,FIND(",",A1)-1)
=LEFT(MID(A1,FIND(",",A1)+2,255),FIND(" ",MID(A1,FIND(",",A1)+2,255))-1)
=MID(A1,FIND("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))),255)

the last one could be as simple as:
=RIGHT(A1,10)
provided ZIP is always 10 characters