| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| USING EXCEL, delete all text right of the "!" symbol | Excel Worksheet Functions | |||
| how to delete automatic 'copyright' symbol insertion | Excel Discussion (Misc queries) | |||
| Can I Delete Symbol in Cell That Has A Formula? | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
| Triangle symbol in cell. What does it mean. How do I delete this | New Users to Excel | |||
Linear Mode
