I want to extract some text from a cell. The text can appear anwhere within
the string such as "OCXO STP 2337A VAR 1 10 MHZ". The text always beings
with "STP" but can appear as follows:

STP 1234
STP 1234A
STP-1234
STP-1234A
STP1234
STP1234A

I have tried the formula =MID(A152,FIND("STP",A152),8) but the MID is
looking for 8 characters and the number of characters are variable.

Thank you in advance.

Esther