Finding Text in a cell
 

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

Finding Text in a cell
 

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

Finding Text in a cell
 

Oh that's perfect thanks so much!

"Ron Coderre" wrote:

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

Finding Text in a cell
 

You're welcome!.....I'm glad I could help.

Regards,

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


"Klee" wrote in message
...
Oh that's perfect thanks so much!

"Ron Coderre" wrote:

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