Formula editing

A

adimar

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.
 
T

Tyro

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

Tyro
 
Top