Finding Text in a cell

  • Thread starter Thread starter Klee
  • Start date Start date
K

Klee

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
 
Try this:

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

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Oh that's perfect thanks so much!

Ron Coderre said:
Try this:

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

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
You're welcome!.....I'm glad I could help.

Regards,

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