Remove function syntax within formula using Replace...is it possible?

[PP3321]

I want to remove this part IFERROR( ,"") in my formula.
Is such thing possible?

I am looking for ways (Macros or otherwise) to do it automatically as there 300 formulas containing IFERROR in my workbook!!!

Thank you!

 

[azumi]

you can use find and replace, even if u try to replace part of formula or full formula, that is simple way and efficient, just try it

 

[PP3321]

@azumi
Thanks. I tried but it does not work.
It says Excel cannot find a match...

 

[PP3321]

I want to remove comma, "" and closing bracket also.

So that it will be just left with mathematical formula...A2/1A

 

[NARAYANK991]

Hi ,

See if this helps :

http://chandoo.org/forum/threads/find-replace-around-reference.29718/#post-177695

Narayan

 

[PP3321]

OK thank you!!!! Sorry I could not find your previous solution.
I will break it down and do replace as you suggest...