Features of !SEMTools

!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.