Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a bit of help editing a formula | Excel Discussion (Misc queries) | |||
No Scroll When editing Formula | Excel Discussion (Misc queries) | |||
Editing a formula | Excel Discussion (Misc queries) | |||
Help with editing a formula | Excel Worksheet Functions | |||
Formula Editing | Excel Worksheet Functions |