Automatic tool for merging many functions of the sheet into one big function

[pszemoc]

Suppose in MS Excel we have cells with values:

A1=3, A2=4

And cells with formulas:

A3=A1+A2
A4=A3*A1

Is there any automatic way (macro or other tool) that would change the last formula in A4 into:

A4=(A1+A2)*A1

So it nests all former functions in brakets creating one long formula out of many formulas in a worksheet. The final formula would refer only to cells with values (not formulas).

[stojko89]

Just click the Cell A4 and enter (A1+A2)*A1 lol and if you want this done for each cell in row 4 just grab the cell and drag it to how far you like so it will do (B1+B2)*B1, (C1+C2)*C1, and so on

[pszemoc]

Thanks for this "uncle advice" but I need automatic tool. Think of a sheet (especially not your sheet) with hundreds of references to previous cells containing formulas. I know it is possible to chore it with hands but I am asking if there is some tool for that. If not, maybe I will write some VBA code for that but I just want to check if there is another way.

[stojko89]

So you want all cells in row 4 to contain information =(1+2)*1 just the letters infront of the numbers changing from A to Z?

[twiggywales]

no i thinks what he as is a formula like this

=F1+G1

in F1 is ="really long difficult formula 1"*B1
in G1 is ="really long difficult formula 2"*C1

in B1 is ="another long one "
and c1is ="the same again but sore :'("

he wants a way to get it all to retrun to 1 cell i guess thus eliminating all the mid steps

(see my attached book)

but i dont know how to automate it.

MEGAFORMULAS.xlsx