| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Finding text in a cell | Excel Worksheet Functions | |||
| Finding a text string w/in a Cell | Excel Discussion (Misc queries) | |||
| Finding the most common cell duplicate (text) | Excel Discussion (Misc queries) | |||
| Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Hybrid Mode
