Advanced Filter with wildcards, Excel 2013

[redrockmtn]

[FONT=&quot]I have an Excel list with many websites. Some end in .com, .net, .org. But some end in .com.mx, .fr, .ru. How do I do an advanced filter to remove all .com.mx, .fr, and .ru while keeping all .com, .net, and .org?[/FONT]

 

[Marcelo Branco]

Example typing in A2
="=*.com"

Before filter

	A​
1​	Text​
2​	=*.com​
3​
4​	Text​
5​	blh.com​
6​	blu.com​
7​	nju.com.fr​
8​	gfty.com.br​
9​	xxx.com​
10​	ght.net​
11​	juy.org​
12​	fff.com​

Apply advanced filter (List range:$A$4:$A$12; Criteria range: $A$1:$A2)

	A​
1​	Text​
2​	=*.com​
3​
4​	Text​
5​	blh.com​
6​	blu.com​
9​	xxx.com​
12​	fff.com​

[/tr]
[/tr]

[/tr]
[/tr]

M.

 

[redrockmtn]

Thanks Marcelo, that did the trick. I was looking for that exact type of wildcard sequence.

Example typing in A2
="=*.com"

Before filter

	A​
1​	Text​
2​	=*.com​
3​
4​	Text​
5​	blh.com​
6​	blu.com​
7​	nju.com.fr​
8​	gfty.com.br​
9​	xxx.com​
10​	ght.net​
11​	juy.org​
12​	fff.com​

<tbody>
</tbody>

Apply advanced filter (List range:$A$4:$A$12; Criteria range: $A$1:$A2)

	A​
1​	Text​
2​	=*.com​
3​
4​	Text​
5​	blh.com​
6​	blu.com​
9​	xxx.com​
12​	fff.com​

<tbody>
</tbody>

M.