How to filter for *

[OSCA]

Hello,

Does anyone know how to filter for * in excel? I've tried a search, but with no luck.

I've got a database where I need to extract anyone with a * in their name and was hoping I could just filter to include *, but looks like this special character won't work.

Thanks for any help!

 

[Aladin Akyurek]

Try...

Begins with

set to:

~*

 

[PaddyD]

or, if you wanted, set up a new column that drives the filter:

=isnumber(find("~*",a2))

...etc

 

[OSCA]

Thank you both!!

It was the ~ that I didn't know about.

Cheers,
OSCA

 

[Haldoug]

Good answers. Thanks for the information about the ~

 

[texasalynn]

again you would have to use
~*