Extracting a Word from a cell that contains a sentence

[onuwayhid]

I am trying to extract a specific word that contains the letters I would like to identify from a cell that contains a long paragraph of text.

Example:

Cell A1: "I AM GOING HOME"

I would like to extract the word from this cell that contains the letters "OIN" and the result should be the word "GOING".

Thank u in advance for your help

[oldchippy]

Without an example, you probably won't get the answer you want