Extract two zip codes from one cell with lots of content

Hi I am trying to pull two 6 digit numbers (zipcodes) out of one cell.
My problem is that I have a lot of content in the cell (both numbers and text). The best way to identify the 6 digit numbers I want is that there is always the same statement before the first zip code "Pick-up at: "random city(length varies)", "random state(always two capital letters)6 digit number"
There is always one space before the number and never any space behind the 6 digit number and the number is always only 6 digits.
Example as follows "Pick-up at: MILFORD, OH 45150"

The second 6 digit number will always have the statement "Deliver to: "random city(length varies)", "random state(always two capital letters)6 digit number"
Example as follows: "Deliver to: WAUSEON, OH 43567"

How can I extract these two 6 digit numbers into two other cells? I can provide samples or more detail. Thank you.
Your help is greatly appreciated.

Worksheet Sample attached.

Hi Leith, thank you for the quick response. The content is being imported into the cell by RSS and HTML code is part of that. If you look into the cell just about midway through you'll see the content I want to extract.
If there is a way to remove the HTML from the cell that is fine with me, I don't need it in this worksheet just comes as part of the RSS feed import.

Thank you for the code shg, but in both A4 and B4 the result is "#NAME?"

Thank you Mike, trying it now.

Mike this does work. Thank you very much.

Thank you shg and Leith for your efforts as well.