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...
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.
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. ( :
Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.
