Find and Replace #DIV/0!
I have inherited a massisve workbook to maintain and when the original
formulas were entered they were not set up to display a dash instead of the
#div/0! error...is there a way to search the entire workbook and auto replace
the formula to surround it with the =IF(ISERROR(old_formula),"",old_formula)
formula?
|