Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.