Convert References in Formula to Containing Formula

[SDings]

I'm sorry for the confusing title but I have no idea how else to word that. The clearest way I can ask this question is with an example. Say cells A1, A2, and A3 contain any value. Now say that B1 contains "=A1+A2" and B2 contains "=A2-A3". Finally, say that cell C1 contains "=B1+B2". Is there a way I can replace a value in a formula, such as B1 with what cell B1 contains? In the end I'd like to have cell C1 equal "=(A1+A2)+(A2-A3)" so that I may eliminate the B1:B2 values... essentially skipping the middle man of formulas.

EDIT: I want this to occur in a click rather than me entering in the values. Ultimately this is for HUGE formulas.

[kvsrinivasamurthy]

Formula given for C1 is free from B cells. Where is the question of middle man?

[Glenn Kennedy]

haven't you answered your own question???

=(A1+A2)+(A2-A3)

[SDings]

I'm not sure what you're asking. If cell C1 contains a formula that currently references B1 and B2, but, B1 and B2 reference A1, A2, and A3. I want to convert the formula inside of C1 to instead of referencing B1 and B2 to instead directly contain the formulas that B1 and B2 have.

[SDings]

I'm looking for this to occur with an option, like a 1 click button of some kind. Not so much as entering it in.

[jason.b75]

C1 contains "=B1+B2". Is there a way I can replace a value in a formula, such as B1 with what cell B1 contains? In the end I'd like to have cell C1 equal "=(A1+A2)+(A2-A3)" so that I may eliminate the B1:B2 values... essentially skipping the middle man of formulas.

EDIT: I want this to occur in a click rather than me entering in the values. Ultimately this is for HUGE formulas.

So you want to delete the 'middle man' cells afterwards?

What you call a middle man, everyone else calls a helper cell, the purpose of which, more often than not, is to help simplify huge formulas.

[SDings]

So you want to delete the 'middle man' cells afterwards?

What you call a middle man, everyone else calls a helper cell, the purpose of which, more often than not, is to help simplify huge formulas.

Which is understandable. Just curious if that was applicable. I'm looking to have a clean excel doc for all to use and if I can delete these cells then I can keep it looking clean easier than anticipated. That or I improve my cell organizational skills. OR I could put the formulas and answers on different sheets. But I was simply curious if it were applicable to just do this.

[jason.b75]

If the middle man / helper cells are all in column B, why not just hide the column?

To do what you want would require a vba procedure (aka a macro) of some kind. A little bit of organisation would probably require a lot less effort.

[SDings]

If the middle man / helper cells are all in column B, why not just hide the column?

To do what you want would require a vba procedure (aka a macro) of some kind. A little bit of organisation would probably require a lot less effort.

I'll be honest. I didn't one could even hide a row/column. That's significantly helpful and will do what I need for now while maintaining a good appearance for the sheet. Thanks!