Extracting Numbers from text

I guess my example didn't include any double digit numbers like 12 or 17.
There will be no triple digit numbers though. Worked well with my sigle digit example.

I have included a third example using your formula here with double digits.

Also I would like to nest this in an if statement. I did it in rows 13 and 14, it seems to work the same way.

=IF(ISNUMBER(SEARCH(Employee,N7)),"YOUR_ARRAY_FORMULA","")

Thanks, Tim