!SEMTools has lots of possibilities to find words in Excel, for every case you just might imagine.

Firstly we need to define “word” – the addin understands it as a sequence of 1 or more alphanumeric characters, delimited either by space or start/end of cell.

So, the first case is when you want to find in a list of cells only those that contain a specific word. Not as a part of any other word, but the whole word itself, even if it’s one letter word, like “a” or “I”.

Finding one word is ok, what to do with several words at once?