| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need simple formula to find one string in another
I need a formula which returns Y if a cell contains a string and N if not.
Here's a start: IF(FIND("XXX",C3),"Y","N"). But the trouble is that if the target string is not found, it returns a #VALUE! error. I can of course fix that by something like IF(ISERROR(FIND("XXX",C3),"N","Y"). But this seems unnecessarily awkward. Is there a simpler solution? I'm using Excel 2003. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mind-numbing simple data validation ... string from 1 to 64 chars | Excel Worksheet Functions | |||
| Find String in another string - only between spaces | Excel Worksheet Functions | |||
| Find Many String options in ONE String | Excel Worksheet Functions | |||
| find text in a string formula | Excel Worksheet Functions | |||
| search string command to answer simple Yes or No | Excel Worksheet Functions | |||
Threaded Mode
