3

I want to search for and replace "*", an actual Shift + 8 asterisk.

There is no option to turn wildcards on and off like there is in Word.

Improve this question

1 Answer 1

Reset to default
5

Use the tilde (~) just before the asterisk to tell Excel that it is a literal.

Ref: http://support.microsoft.com/kb/214138

Improve this answer
3
  • Just out of curiosity, what do you do if you need to search for a tilde? Would you use "~~"?
    – PFitz
    Jul 2, 2014 at 14:59
  • Yes. Note, this is the second example in the MS support link.
    – Madball73
    Jul 2, 2014 at 15:03
  • It sure is. I got a little lazy there. Thanks.
    – PFitz
    Jul 2, 2014 at 15:06

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .