Custom Autofilter List
 

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
"Alex Lush" wrote in message
...
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