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.