How to check whether a cell INCLUDES a given character string

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

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!
 
Or to be a bit more positive <bg>

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

=find() is case sensitive
=search() is not
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove certain characters from a text string 6
Autocopy the first cell with more than 30 characters to a different sheet? 1
Possible to select a string in a locked cell? 1
Text string searches 3
search text for substring and change text colour of substring 5
Need to append a character to cell data 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Deleting part of a cell 2

Back
Top