Search text in a cell

[Guest]

If I have a sentence in a cell, what code can I use to search a word in that
cell?
Eg: A1: "I am happy"
I want to test if A1 has the word "happy" in it.

 

[T. Valko]

One way:

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

Will return either TRUE (yes it does) or FALSE (no it doesn't)

Biff

 

[dzelnio]

I used VLOOKUP to search for a keyword and it works great.

 

[Guest]

Another way...........

=MID(A1,FIND("happy",A1,1),5)

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

Another one:

=if(countif(a1,"*happy*")>0,"yep","nope")