find information

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

Is there a way to look in a cell and find a particular
string of data and categorize that as "TRUE" if the
string is found and "FALSE" if not?

I've tried =or(B2="*AWEN*")
but this does not return a "TRUE" result, even though the
cell B2 looks like this "TECO AWEN"

Any ideas?

TIA,
Brenda
 
Try

=ISNUMBER(FIND("AWEN",B2))

Note that find is case sensitive, you can use search if you don't want it to
be case sensitive
 
Minor point but she did ask for "true" and "false" with quotes around them.

=+TEXT(ISNUMBER(COUNTIF(B2,"*AWEN*")),)
 
Back
Top