!SEMTools has a wide range of methods for searching for words in cells, for all occasions.
First of all, let’s define the concept of “word”. The add-in considers as a word one or more characters separated from each other by a space or the end/beginning of a line.
Find a specific word in cells
Search for a single word in an array of cells. Sometimes in a large array of phrases, you need to find those that contain a single, but exclusively whole word not contained in others.
Find words from a list in a range
Finding a single word is half the trouble. What do you do when you need to find a list of words?
Find repeated words in cells
Sometimes you need to find cells that contain not any specific words, but words that repeat within a cell. Then the Find Repetitive Words in Cells function comes to the rescue.