View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
se7098 se7098 is offline
external usenet poster
 
Posts: 79
Default 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?