try using this

=IF(ISERROR(Your formula),"",Your formula)

or

=IF(ISERR(Your formula),"",Your formula)

to place a 0 instead of blank, change "" to 0

HTH
--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis









"wanttolearn" wrote:

I'd like to replace #DIV/0!
with a blank or a 0 in the cells that have this after I copy a formula to a
range of cells. Replace doesn't recognize the symbol.