Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to replace all # to blank.
In my worksheet, there are some of the box are fill with color, the arther
all are numbers. so, how to use a formula or macro to replace all numbers to blank. and just keep the color box. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to replace all # to blank.
R-click, Clear contents?
John wrote: In my worksheet, there are some of the box are fill with color, the arther all are numbers. so, how to use a formula or macro to replace all numbers to blank. and just keep the color box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
replace error with blank | Excel Worksheet Functions | |||
replace - by blank, keep 0 in phonenumber | Excel Worksheet Functions | |||
Replace cells with blank | Excel Worksheet Functions | |||
replace N/A by a blank | Excel Discussion (Misc queries) |