delete the actual symbol *

  • Thread starter simple user with problem
  • Start date
S

simple user with problem

I made the mistake of adding the * symbol to some entries that I wanted to
flag. Now I can not search for them because the * is seen as a wild card
character and every cell is found by the FIND function. Is there anything I
can do?
 
G

Gord Dibben

Search using the tilde(~) which is a wildcard charater that overrides other
wildcard charaters.

~* or ~?


Gord Dibben MS Excel MVP

On Thu, 3 Jul 2008 11:42:00 -0700, simple user with problem <simple user with
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The @ symbol 7
Why doesn't a ' symbol show up at start of Excel cell 1
How do I eliminate a symbol? 1
Excel Symbol 2
Automatically inserting a symbol when text is entered in the cell 1
Type a symbol useing shortcut keys rather the insert a symbol 2
How to detect symbol/special character code 19
how to replace an unrecognised character 2

Top