Here is a function (can be used as a UDF - user defined function if desired) that locates the position of the exact word (that is, a word that is not embedded within a larger word) in a given text string which I think you can make use of. If the exact word does not exist within the text, then the function returns 0 for its position.
The function has two required arguments and two optional arguments... the first argument is the main text to search, the second argument is the exact word (or phrase) to look for, the third argument is optional and sets the starting position in the main text to begin searching from (the default starting position if the argument is omitted is 1) and the fourth argument, also optional, is a Boolean (True or False) for whether the search is case sensitive or not (the default if it is omitted is False meaning the search is case insensitive).
Bookmarks