Friday, December 17, 2004

MS Excel:Search for an Asterisk, Question Mark, or Tilde

Since these characters have special meanings in Excel, you will need to precede them with a tilde to be able to search for them successfully.
So, to find an asterisk, Edit>Find, and then type ~* in the Find dialog box;
to find a tilde, type ~~;
to find a question mark, type ~?.

No comments: