If "xxxx" is in a cell, then TRUE

[Guest]

I want to look at a cell and if the word "ave" appears anywhere in the cell
then I want a return of TRUE.

I think that EXACT, OR or IF will work somehow but I want true if the word
is "old ave', "1735 fairmont avenue" or "good aver", not only "ave" by itself.

 

[Biff]

Hi!

Try this:

=ISNUMBER(SEARCH("ave",A1))

Biff

 

[Alan]

One way
=IF(ISERROR(FIND("ave",A1)),FALSE,TRUE)

 

[Dave Peterson]

One more...

=COUNTIF(A1,"*ave*")>0

I want to look at a cell and if the word "ave" appears anywhere in the cell
then I want a return of TRUE.

I think that EXACT, OR or IF will work somehow but I want true if the word
is "old ave', "1735 fairmont avenue" or "good aver", not only "ave" by itself.