Deleteing

K

koba

Hi all

How do i delete all the cells in a column in which a formula did not
work, leaving the cells where the formula did work?

Example
#DIV/0!
#VALUE!
193%
49%
#VALUE!
44%
-11%
-23%
#VALUE!
#VALUE!

Without going through them individually

as there is a lot and i dont want to do that....

thanks
Andrew
 
R

Ron Coderre

Try this:
Select the range you want to test
Edit>Go to
Click the [Special Cells..] button
Select:
Formulas
Uncheck everything except Errors
Click [OK]

If that selects the right cells....
Press the [Delete] key...Done

Does that help?

***********
Regards,
Ron
 
Top