Is it possible to use SEARCH to search This or That?
Now the data in the cell is like:
Mister A and Master B are friends
What I would like to do is if the formula can find either Mister or Master then it's TRUE.
Is there any suggestion?
Now the data in the cell is like:
Mister A and Master B are friends
What I would like to do is if the formula can find either Mister or Master then it's TRUE.
Is there any suggestion?