OTHER EXCEL FUNCTION COUNTER SOLUTION ?
I still don't get it.
What makes you so sure you want or need those changes.
Are you the one who created those workbooks ?
Are you sure the "new" behaviour is the one you want in every situation ?
Your workbooks were never tested for acuracy ?
We are not talking about a way to get around a bug here, we are talking
about interpretation of the syntax. Making formula changes blindly could have
serious effects, not automatically good ones...
--
Regards,
Luc.
"Festina Lente"
"romelsb" wrote:
thanks Harlan....you got a big deal of solution....if i can just click the
check bottun a 10 times I´ll do it...hope others think the way you did....
--
"Bright minds are blessed to those who share them.."-rsb.
"Harlan Grove" wrote:
romelsb wrote...
....
. . . I kindly request your help to reestablished
confidence on engineer´s excel workbooks:
I NEED A FIND/REPLACE COMMAND FORMULA....
e.g.
=-A1^(A2+A3)
BASED FROM ABOVE :
I LIKE TO FIND ALL THE ABOVE AND REPLACE it with
=-1*A1^(A2+A3)
....
You could try the following 3-step find/replace process.
1. Select all cells containing formulas.
2. Replace all - with -1* .
3. Replace all ^-1~* with ^- .
The 3rd step unfubars exponents because even bodmas doesn't like
changing x^-2 to x^-1*2. Of course that means you won't fix things like
x^-y^-z.
The alternative task of changing all -x^y to -POWER(x,y) requires the
equivalent of a formula parser. Not trivial. Requires VBA or similar
programming.
|