Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need a simple rule that checks if a cell contains the char *. If i put * in the rule, it matches the entire string so i figured * is a wildcard. Is it possible to make it search for the char ? I tried escaping it like '', "*" or *.

What I want is text not being shown but text* should be noticed by the rule.

Any hints?

share|improve this question
up vote 6 down vote accepted

To search for the cells containing the wildcard character (*), use a tilde before it inside the search box:


Now Excel will show you only the cells that contain the wildcard character (*).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.