Formula editing
 

I usually edit complex formulas in a text editor, especially if I want to
replace constructs, ex: replace string check for €œPROD_1€� with €œNPRODX_2€�.

Is there a way to extend the Excel Find/Replace to formulas? This would be
very helpful in replicating entire sets of formulas for different check
strings or criteria.

Thank you.

Formula editing
 

=SUBSTITUTE(A1,"PROD_1","NPRODX_2")


"adimar" wrote:

I usually edit complex formulas in a text editor, especially if I want to
replace constructs, ex: replace string check for €œPROD_1€� with €œNPRODX_2€�.

Is there a way to extend the Excel Find/Replace to formulas? This would be
very helpful in replicating entire sets of formulas for different check
strings or criteria.

Thank you.

Formula editing
 

Excel find/replace works with formulas. Just select the formulas like you
would anything else and do a find/replace.

Tyro

"adimar" wrote in message
...
I usually edit complex formulas in a text editor, especially if I want to
replace constructs, ex: replace string check for "PROD_1" with "NPRODX_2".

Is there a way to extend the Excel Find/Replace to formulas? This would be
very helpful in replicating entire sets of formulas for different check
strings or criteria.

Thank you.