Hello everyone.

I'm looking at a column in Excel full of various addresses. Here's what I'm trying to do:

If and only if an address contains the string "zone" then I want to put that zone number in another column.
For instance, an address might contain "zone 18". I would want the new column to display 18.
This number would always be preceded by the word "zone".

I've tried to do this already using nested IFs, FINDs, SEARCHs, but I'm probably making it way too complicated.

Thanks in advance for any help you all could give.