Is there a way that I can check a cell to determine if it contains a specific
word in a string of words? For example if there is a sentence in C4 and I
need to know if the word "Apples" is within the sentence.

I would like to have an if formula that says =if(C4 contains the word
apples,"Apples",C4) .

I just dont know how to fine one word within a cell.

Thanks