| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching Cells in Excel
Thank you very much for your swift reponce. This sounds like the right
formula, but its just returning a number 16. I need it to say True if it appears in the sentence, or a " 1" will do -- Duncan "antoka05" wrote: if you need to know if the word present in cell A1 is in the cell B1 text you can put this formula in cell C1: =FIND(A1,B1,1) -- antoka05 ------------------------------------------------------------------------ antoka05's Profile: http://www.excelforum.com/member.php...o&userid=29024 View this thread: http://www.excelforum.com/showthread...hreadid=487562 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| searching 2 values from 2 cells | Excel Discussion (Misc queries) | |||
| Searching for Linked Cells | Excel Discussion (Misc queries) | |||
| Searching a cells contents? | Excel Worksheet Functions | |||
| Searching for string in other cells | Excel Worksheet Functions | |||
| Is there any way of searching for duplicate cells? | Excel Discussion (Misc queries) | |||
Hybrid Mode
