Extracting Zip Code from Address String

[lizzae]

I have several thousand entries in a spreadsheet that represent an address. The string contains the streeet address, an apartment if applicable, the city, state and the zip.
I am trying to parse this string into five columns: Address 1, Address 2, City, State and Zip. Each cell is a different length with no delimeter I can see. I'm trying to find the easiest/fastest way to do this.
Thanks!!

Example:
PO Box 7211 TERMA CA 92274-0786
53455 CLEARED WAY GLEN BURNIE MD 21060-0878
CASTLE COTTAGE #133 700 SMITH STREET EASTON MD 21601-0953
6458 WHEATON CIRCLE #D215 TAMPA FL 33321-0988
PO Box 185 EXETER, VA 23562-0993

[mhuston]

Please Login or Register  to view this content.

Where A1 is the cell with the full address.