Filter for a single- and two-character word

[YoupC]

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

 

[Marcelo Branco]

Welcome to Mr Excel

Try Advanced Filter + a formula
Something like this

Before filter

	A​	B​	C​
1​	Text​
2​	xxxx uxyx vguwx​		FALSE​
3​	uw vgty​
4​	xxx uw​
5​	xxx uw zzzz​
6​	u xxxx​
7​	xxxx u​
8​	uxxx uwzzz​
9​	uzzz uwxxxx​

<tbody>
</tbody>

Leave C1 blank

Formula in C2
=OR(ISNUMBER(SEARCH(" "&"u"&" "," "&A2&" ")),ISNUMBER(SEARCH(" "&"uw"&" "," "&A2&" ")))

Apply Advanced Filter
List Range: $A$1:$A$9
Criteria Range:$C$1:$C$2

After adv filter

	A​
1​	Text​
3​	uw vgty​
4​	xxx uw​
5​	xxx uw zzzz​
6​	u xxxx​
7​	xxxx u​

<tbody>
</tbody>

Hope this helps

M.

 

[YoupC]

Works like a charm, Marcelo. Thanks for the quick reply!!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.