Forum Discussion
Solved
How do I Find/Replace or Filter with exact words/characters?
Requirement 1: I want to be able to filter the cells to the letter "a" or "is" Requirement 2: I want to be able to Find and Replace the word "is" with should be Issue 2: When I search for "is", ...
You may wrap it by spaces searching for " is ".
In Find and Replace options check Match entire cell content
In column Filter you may select Text Filter -> Equals
Hi SergeiBaklan - this does not work.
The reason is that for that feature to work the cell must contain nothing but the word "is".
For example, if I have a cell F1 with a value "My name is Matt" and I search for "is" and have "match cell contents" to true, then it will not find cell F1 because the cell contents contains words other than "is".
If the cell just contained "is" and nothing else then your solution would work.
Thanks for trying!
You may wrap it by spaces searching for " is ".
- I wasn't able to search for " is " in Excel 2016.
In fact, using the double quotes or even single quotes. the search didn't show any result.
Even using a space before and after " is ", or when I searched without a space "is".
Am I missing something or is it not possible in Excel 2016?
