I have a spreadsheet that contains text strings in Dutch. I'm trying to single out all the rows that contain either the Dutch words "u" or "uw." Both words will have a trailing space, a leading space or both, depending on where they occur in the text string.
Is there a way to filter for these words including one or two spaces?
I've been trying all kinds of filter settings to do this, but can't figure out how to add spaces to the search items when creating the text filter. Excel ignores the spaces when I just add them to the search string. The result is that also strings containing words that include these two characters, like "jouw" or "zult", show up.
Anybody any suggestions? Thanks!
Using Excel 2016 on W10
Is there a way to filter for these words including one or two spaces?
I've been trying all kinds of filter settings to do this, but can't figure out how to add spaces to the search items when creating the text filter. Excel ignores the spaces when I just add them to the search string. The result is that also strings containing words that include these two characters, like "jouw" or "zult", show up.
Anybody any suggestions? Thanks!
Using Excel 2016 on W10
