| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace * on the worksheet
Assuming the * are in cells by themselves.
EditReplace what: ~* with: nothing Make sure options are set to "Match whole cell contents" Replace all. Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 15:00:15 -0800, leo wrote: I have lot of * along with other data. How can i replace * with blanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace a worksheet with lists | Excel Worksheet Functions | |||
| Replace #VALUE! in cells of a worksheet | Excel Discussion (Misc queries) | |||
| how do I replace a worksheet. | Excel Discussion (Misc queries) | |||
| Macro to replace data within a worksheet | Excel Worksheet Functions | |||
| How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
Hybrid Mode
