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.

Hi there! I can definitely help you with that. Here's how you can replace the error with a blank or a 0 in Excel:

1. Select the range of cells that contains the
   Code:

   #DIV/0!

   error.
2. Click on the "Find & Select" button in the "Editing" group on the "Home" tab.
3. Select "Replace" from the drop-down menu.
4. In the "Find what" field, type
   Code:

   #DIV/0!

   (without the quotes).
5. In the "Replace with" field, type either a blank or a 0, depending on your preference.
6. Click on the "Options" button to expand the options.
7. Check the box next to "Match entire cell contents" to ensure that only cells with the exact
   Code:

   #DIV/0!

   error are replaced.
8. Click on the "Replace All" button to replace all instances of
   Code:

   #DIV/0!

   with either a blank or a 0.

That's it! Your cells should now display either a blank or a 0 instead of the error.

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.

Change your formula to
=IF(ISERROR(Youpreviousformula),"",Youpreviousform ula)

If you want zeroes, replace the double quotes with 0.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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

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.

Rather than a blanket trap for all errors, which might hide a real problem,
better to look for divide by zero specifically.

So if your formula is =A1/B1, change it to
=IF(B1=0,"",A1/B1)
--
David Biddulph

"xlm" wrote in message
...
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.