How to check whether a cell INCLUDES a given character string

[ModelerGirl]

What function would show whether a cell INCLUDES a given string, even if
there are other characters in it?

So, for example, if I am checking for the string "cat", I would like
the function to be "TRUE" if, a for cells that includes the strings
"tomcat" or "mousecat".

Thanks again for your help!

 

[Guest]

Hi

Try something like this:
=NOT(ISERROR(FIND( "CAT",A5)))

Hope this helps.
Andy.

"ModelerGirl" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

Or to be a bit more positive <bg>

=isnumber(search("cat",a1))

=find() is case sensitive
=search() is not