Hi!

Try this:

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

Biff

"Tommy Boy" wrote in message
...
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.