ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofilter to search characters that begin with "* " (https://www.excelbanter.com/excel-discussion-misc-queries/55694-autofilter-search-characters-begin-%2A.html)

Barb Reinhardt

Autofilter to search characters that begin with "* "
 
I'm having difficulty getting Autofilter to work with text that begins with
"* ". It appears that * is a wild card, but I don't want to search that
way. Any suggestions?

Thanks,
Barb Reinhardt

Duke Carey

Autofilter to search characters that begin with "* "
 
So..you're trying to use a custom filter within Autofilter?

Use Begins with and then, in the text box, precede the asterisk with a tilde

~*

"Barb Reinhardt" wrote:

I'm having difficulty getting Autofilter to work with text that begins with
"* ". It appears that * is a wild card, but I don't want to search that
way. Any suggestions?

Thanks,
Barb Reinhardt



All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com