MS Access Update Query

I have the below data in a field and need to parse out the City and State, leaving only the Zip Code. I would like to know the proper statement to remove this data.
Colorado Springs,CO 80913
Arvada,CO 80005
Denver,CO 802041736