Custom Autofilter List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'd like to do a custom autofilter to show all rows where a particular field
starts with a question mark. The problem is that excel thinks that the
question mark is a wildcard repreenting a single character. How do I get
round this? I presume you have a similar problem when looking for all items
beginning with a * character as this is also a wildcard character.

Hope that sounds understandable and thanks in advance.

Regards,

Alex
 
In your customer filter, try this:

Begins with "~?" No Quotes

HTH,
Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell 2
Use of Wildcard characters with replace 2
subtotals with custom autofiltering 1
Filter Data using wildcards 1
How to avoid '*' being used as wildcard in SUMIF? 6
autofilter 4
Finding and deleting question marks 3
wildcards in formulas 1

Back
Top