To make your errors to your formulas not appear use the following

=if(iserror(your formula)," ",(type your formula again))

This should keep the cell blank until the right criteria is available for
your formula to calculate.

"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.