View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default OTHER EXCEL FUNCTION COUNTER SOLUTION ?

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.