find information

[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

 

[Peo Sjoblom]

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

 

[Jason Morin]

One way:

=COUNTIF(B2,"*AWEN*")

HTH
Jason
Atlanta, GA

 

[Brenda]

GREAT! It works perfectly. Thank you very much!

Brenda

 

[Dave R.]

Minor point but she did ask for "true" and "false" with quotes around them.

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