Try this:

=IF(COUNTIF(C4,"*APPLES*"),"Apples",C4)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Klee" wrote in message
...
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