| 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 |
| 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 | |||
Threaded Mode
