Is there a Quick way to change all instances of IFNA to IFERROR throughout the entire workbook?

[Excelerate2014]

2010 does not recognize IFNA and I will have to use 2010 at times. Is it possible to make a one-time global change to IFERROR within every applicable formula in the workbook?

Thanks,

 

[Michael M]

One way...
Slect ALL the sheets using CTRL + Click on Each Tab
The use Find / Replace for IFNA with ISERROR

 

[gwono]

Alternatively just go Find / Replace - Options - Within (Workbook)

 

[Michael M]

@gwono
Agreed......as long as they want to do that in EVERY Sheet, rather than being selective !!....