| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
True/False for finding text in cells
Your right, I was thinking of the INSTR in VBA.
"David Biddulph" wrote: Which version of Excel is that, Joel? With Excel 2003, FIND returns #VALUE! if the text is not found. -- David Biddulph "Joel" wrote in message ... Find doesn't return an error, it will return zero if not found or the character position where the string starts =if(find("text",A1)=0,False,True) "pdi805" wrote: Is there a simple formula for checking if a cell contains a text string, which returns a TRUE/FALSE? It is possible to combine "ISERROR" and "FIND", but this becomes a pain when you have to do it all the time. Instead of using the reverse logic of: =if(iserror(find("text",A1))=FALSE,... it would be so much easier to write: =if(contains("text",A1),... This is a very basic thing you can do with an autofilter, so it seems like there would be a function that does this without returning error values. Any suggestions? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
| Calculate true/false value based on array text input | Excel Worksheet Functions | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| how to change colour of text in true or false formula | Excel Worksheet Functions | |||
| need array of true/false if text exists | Excel Worksheet Functions | |||
Threaded Mode
