Hi all,

I have a spread sheet with a column that includes a random amount of text like so:

-----------------------


Contact Name:


Contact Email:


Contact Phone:

I am interested in 1234NE 12Tth, Williston, FL 32696.


Search CriteriaCity :
State :
ZIP : 0
MinLotSize : 0
MaxLotSize : 0
MinYearBuilt : 0
MaxYearBuilt : 0
PropertyTypes : CondoApartment, LotsLand, Manufactured, MultiFamily, SingleFamily

-------------------

What I want to do: Extract only the zip code from this column.
My problem: I cannot find a formula to complete this task because every cell is different. Some may display the above posted or some may have double the text, so I am not sure how to pinpoint the formula to do what I want it to do.

The words "I am interested in" appear in a majority of cells in the column, followed by the respective state, if that helps.