| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Block deleting all zeros at once.
In Excel2003 Is there a way of block deleting all zero
values from 3 columns of data. If not could anyone suggest a function to do this. Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Block deleting all zeros at once.
Use Find and Replace, replacing "0" with nothing. Be sure to select the
"Match entire cell contents" option. -- Jim Rech Excel MVP |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Block deleting all zeros at once.
Oh, be sure to select the range before you do this or the entire sheet will
be searched. -- Jim Rech Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows containing zeros | Excel Discussion (Misc queries) | |||
| Deleting rows (with zeros) with a macro | Excel Worksheet Functions | |||
| Deleting rows (with zeros) with a macro | Excel Worksheet Functions | |||
| How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) | |||
| Deleting Lead Zeros | Excel Worksheet Functions | |||
![Ben[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
