If "xxxx" is in a cell, then TRUE
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.
|