True/False for finding text in cells

  • Thread starter Thread starter pdi805
  • Start date Start date
P

pdi805

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.
 
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)
 
Your right, I was thinking of the INSTR in VBA.

David Biddulph said:
Which version of Excel is that, Joel?
With Excel 2003, FIND returns #VALUE! if the text is not found.
Click to expand...
 
Back
Top