Really just what the title says. I have a variety of strings that I am searching through for certain words, for example:
“You are acting out of line” OR “It was all just an act”
With the word “act” being the word I am searching for. With the normal FIND function, it would come up with a number for both because both strings contain the string “act”. What I would like is for the first string to give an error when run through FIND, and the second to come up positive because it contains the whole word and not a word that contains it.
Is there any way to do this, and if so, how?