How to find words in Excel (by exact match)

How is searching by words different from a simple text search?

Mainly because when searching for short words using regular text matching, you might end up finding them inside other words. This means your filter results can include cells you don’t actually need.

Searching by words ensures that only cells where the words match exactly are shown.

Searching for a single word

Let’s start with the simple case—finding one word.

Filtering by a word in Excel

Excel’s filter tool offers three text filter methods—meaning you can filter by three matching patterns:

1. Cell contains the word — add spaces before and after the word.
2. Starts with the word — add a space after it.
3. Ends with the word — add a space before it.

The problem is Excel can’t filter by all three criteria at once—you can only use two. Here’s a simple workaround:

1. Make a copy of the original column.
2. Remove all characters except letters, numbers, and spaces.
3. Add a symbol to the start and end of each cell, for example “\”.
4. Replace remaining spaces with the same symbol.
5. Filter by your target word with “\” before and after it (e.g., “\word\”).

The “\” symbol ensures you’re filtering for whole words only.

As you can see, there are five steps—so if you only need to find one word once, it’s easier to just filter three times. But if you’ll be searching for multiple words, this will speed things up.

Example:

Another option is to add spaces at the start and end of the text. In this case, when searching or filtering, you must use the “*” wildcard before the left space and after the right space—otherwise Excel won’t recognize the spaces.

So, to search or filter by a word in Excel, add a space to the left and right of all cells in the column, then search or filter by the word including those spaces.

Searching for a word in a cell: formula

The ideal function for a formula-based word search is SEARCH.

Formula:

=SEARCH(" "&"yourWord"&" ";" "&A1&" ")>0 

Here yourWord is the word you’re searching for, and A1 is the cell where you’re looking for it.

Remember to remove punctuation first.

Searching by word in Excel using !SEMTools

The fastest method—available to full-version users of my Excel add-in. The process is simple: select the range, run the macro, type the word, and click OK.

Searching for multiple words

How can you check if each cell in a large range contains at least one word from a list—and make sure you’re finding whole words, not just text fragments inside other words? And what if you need to search hundreds of words across tens of thousands of cells?

Find any word from a list

!SEMTools handles this easily. Regardless of the list size, detection is very fast—even in ranges of 10,000+ cells.

To find a list of words in a range with !SEMTools:

1. Copy the range to another column to preserve original data.
2. Run the macro from the add-in’s panel.
3. Select the list of words to search for.
4. Click OK.

The macro checks whether a cell contains at least one word from the list.

Practical use cases

This is often used before two other actions—extracting words from a list and deleting a list of words from text. Why not do these right away? Because extraction is slower, and deletion won’t show which cells were affected.

Examples: PPC specialists might search for purchase or rental markers, reviews, or check long negative keyword lists to exclude certain queries from campaigns. Or, if you want to know whether a price list contains items from certain manufacturers (whose list you already have), this macro will help.

Find all words from a list

This search works the same way, except it returns TRUE only if all the words in the list are present in the cell. Quite a rare task though.

This post is also available in RU.