One way:

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

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

Biff

"J@Y" wrote in message
...
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.