jump to navigation

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

Posted by Steven in Work-related.
trackback

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

Comments»

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

9to5Mac

Apple iPhone, Mac and iPad News Breaking All Day

Facebook IQ

Real Life. Real Insight. Real Action.

TED Blog

The TED Blog shares interesting news about TED, TED Talks video, the TED Prize and more.

TechCrunch

Startup and Technology News

Quartz

Quartz is a digitally native news outlet for the new global economy.