Excel - Combining two cell formulas into one cell

Is there any easier way to combine formulas into one cell other than just copy and paste the formula text?

I have a long complicated formula that I split into two distinct formulas and then combined them in a third cell. But now I want everything in one cell, one formula.

This is an over simplification but say I have: A2=A1^2; B2=B1*A1; C2=MAX(A2,B2)

But I want to switch to have: C2=MAX(A1^2,B1*A1)

Without having to go in and copy/paste each individual formula into C2.

Using a mouse or arrow keys to select just the right text to replace is obnoxious.

2

1 Answer

I suggest to use substitute() & concatenate()

E2 ---> '=max(
F2 ---> =SUBSTITUTE(C2,"=","")
G2 ---> ,
H2 ---> =SUBSTITUTE(FORMULATEXT(B2),"=","")
I2 ---> )
J2 ---> =CONCATENATE(E2,F2,G2,H2,I2)

Then.. you can copy the contents of J2 as the formula to fill in C2.

Hope it helps. ( :

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy