jump to navigation

Tipp for working with filters / text-filters in Microsoft Excel December 15, 2009

Posted by Steven in Work-related.

For some database related work / spreadsheet work I had to find a way in Excel’s text filter system to escape characters. Specifically: it you need to know exactly what to type in when you want to look for example for the character “?” in an Excel column or range.

Here is how you do it (I explain it on the example of Excel’s auto filtering):

  • select the range or columns
  • Ribbon Data > hit Filter button
  • Click the little down triangle on the column / header of the column you need to filter
  • Enter “Text filters” e.g. “Contains”
  • In the dialogue ‘contains what’.. enter ~ ? for example (to search for actual ? characters


No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


technology and life hacking

CodeinWP Blog

Designer's guide to WordPress

Elegant Themes Blog

technology and life hacking


technology and life hacking