delete the actual symbol *
 

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?

delete the actual symbol *
 

Hi,

Use the Tilde

~*

Mike

"simple user with problem" wrote:

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?

delete the actual symbol *
 

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
wrote:

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?