Formula editing

  • Thread starter Thread starter adimar
  • Start date Start date
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.
 
Excel find/replace works with formulas. Just select the formulas like you
would anything else and do a find/replace.

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to replace a formula string with * in the leading position? 3
IF AND Nested Functions - Formula Not Working 0
Searching the formula (not the value) for a text string 1
Keep text matching a wildcard spec in replace/substitute 3
With F1 value, look at A, if match or partial match return B 5
Convert Array Formulas to Regular Formulas 4
using the =page! feature to transpose a row to column 0
How do I find & replace pieces of a formula? 4

Back
Top