Forum Discussion
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", the words "list" and "display" show up and so the output is lshouldt and dshouldplay
Is this possible without VBA?
Thanks
You may wrap it by spaces searching for " is ".
10 Replies
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 ".
