Formula editing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

adimar - 06 Feb 2008 20:06 GMT

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.

Reply to this Message

Teethless mama - 06 Feb 2008 20:28 GMT

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

> 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”.
[quoted text clipped - 4 lines]
>
> Thank you.

Reply to this Message

Tyro - 06 Feb 2008 22:49 GMT

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

Tyro

>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".
[quoted text clipped - 4 lines]
>
> Thank you.

Reply to this Message