Excel - Combining two cell formulas into one cell












0














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.






microsoft-excel







share|improve this question






















  • VBA code can easily solve your problem. But if the formulas in A and B are row-dependent only, you can build one formula by copy-paste, and then use drag down to fill all the range.
    – Akina
    Oct 2 at 17:09










  • If you want to use the shown Formula without reach to Cell C2 or Copy & Patse then you many try like this in Immediate Window Range("C2").Formula= "=MAX(A1^2,B1*A1)"
    – Rajesh S
    Oct 8 at 10:58


















0














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.






microsoft-excel







share|improve this question






















  • VBA code can easily solve your problem. But if the formulas in A and B are row-dependent only, you can build one formula by copy-paste, and then use drag down to fill all the range.
    – Akina
    Oct 2 at 17:09










  • If you want to use the shown Formula without reach to Cell C2 or Copy & Patse then you many try like this in Immediate Window Range("C2").Formula= "=MAX(A1^2,B1*A1)"
    – Rajesh S
    Oct 8 at 10:58
















0












0








0







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.






microsoft-excel







share|improve this question













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.






microsoft-excel




microsoft-excel






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Oct 2 at 17:00









Jack Hupp

1




1












  • VBA code can easily solve your problem. But if the formulas in A and B are row-dependent only, you can build one formula by copy-paste, and then use drag down to fill all the range.
    – Akina
    Oct 2 at 17:09










  • If you want to use the shown Formula without reach to Cell C2 or Copy & Patse then you many try like this in Immediate Window Range("C2").Formula= "=MAX(A1^2,B1*A1)"
    – Rajesh S
    Oct 8 at 10:58




















  • VBA code can easily solve your problem. But if the formulas in A and B are row-dependent only, you can build one formula by copy-paste, and then use drag down to fill all the range.
    – Akina
    Oct 2 at 17:09










  • If you want to use the shown Formula without reach to Cell C2 or Copy & Patse then you many try like this in Immediate Window Range("C2").Formula= "=MAX(A1^2,B1*A1)"
    – Rajesh S
    Oct 8 at 10:58


















VBA code can easily solve your problem. But if the formulas in A and B are row-dependent only, you can build one formula by copy-paste, and then use drag down to fill all the range.
– Akina
Oct 2 at 17:09




VBA code can easily solve your problem. But if the formulas in A and B are row-dependent only, you can build one formula by copy-paste, and then use drag down to fill all the range.
– Akina
Oct 2 at 17:09












If you want to use the shown Formula without reach to Cell C2 or Copy & Patse then you many try like this in Immediate Window Range("C2").Formula= "=MAX(A1^2,B1*A1)"
– Rajesh S
Oct 8 at 10:58






If you want to use the shown Formula without reach to Cell C2 or Copy & Patse then you many try like this in Immediate Window Range("C2").Formula= "=MAX(A1^2,B1*A1)"
– Rajesh S
Oct 8 at 10:58












1 Answer
1






active

oldest

votes


















0














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. ( :






share|improve this answer























  • Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
    – Rajesh S
    Oct 8 at 11:22










  • noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
    – p._phidot_
    Oct 8 at 11:25











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1363329%2fexcel-combining-two-cell-formulas-into-one-cell%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














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. ( :






share|improve this answer























  • Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
    – Rajesh S
    Oct 8 at 11:22










  • noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
    – p._phidot_
    Oct 8 at 11:25
















0














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. ( :






share|improve this answer























  • Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
    – Rajesh S
    Oct 8 at 11:22










  • noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
    – p._phidot_
    Oct 8 at 11:25














0












0








0






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. ( :






share|improve this 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. ( :







share|improve this answer














share|improve this answer



share|improve this answer








edited Dec 6 at 7:38

























answered Oct 8 at 10:33









p._phidot_

56429




56429












  • Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
    – Rajesh S
    Oct 8 at 11:22










  • noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
    – p._phidot_
    Oct 8 at 11:25


















  • Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
    – Rajesh S
    Oct 8 at 11:22










  • noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
    – p._phidot_
    Oct 8 at 11:25
















Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
– Rajesh S
Oct 8 at 11:22




Op's issue is,, Without having to go in and copy/paste each individual formula into C2.
– Rajesh S
Oct 8 at 11:22












noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
– p._phidot_
Oct 8 at 11:25




noted.. I have no way of doing it via formulas.. so I suggested these to reduce the number of <select-copy-paste> from 3 to 1. I'm a noob in vba. | :
– p._phidot_
Oct 8 at 11:25


















draft saved

draft discarded




















































Thanks for contributing an answer to Super User!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1363329%2fexcel-combining-two-cell-formulas-into-one-cell%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Terni

Image
Questa voce o sezione sull'argomento Umbria non è ancora formattata secondo gli standard . Contribuisci a migliorarla secondo le convenzioni di Wikipedia. Segui i suggerimenti del progetto di riferimento. Terni comune Localizzazione Stato   Italia Regione Umbria Provincia Terni Amministrazione Sindaco Leonardo Latini (Lega Nord) dal 25-06-2018 Territorio Coordinate 42°34′N 12°39′E  /  42.566667°N 12.65°E 42.566667; 12.65  ( Terni ) Coordinate: 42°34′N 12°39′E  /  42.566667°N 12.65°E 42.566667; 12.65  ( Terni ) Altitudine 130 m s.l.m. Superficie 211,90 km² Abitanti 111 189 [1] (31-12-2017) Densità 524,72 ab./km² Frazioni Vedi elenco Comuni confinanti Acquasparta, Arrone, Colli sul Velino (RI), Labro (RI), Montecastrilli, Montefranco, Narni, Rieti (RI), San Gemini, Spoleto (PG), Stroncone Altre informazioni Cod. postale 05100 Prefisso 0744 Fuso orario UTC+1 Codice ISTAT...
Read more

A new problem with tex4ht and tikz

Image
3 When run through pdflatex the code snippet below produces: but when I run it through make4ht the following web page, without the numbers, is generated: (The difference in scale is an artifact of my skills in taking screenshots.) Here is the code: documentclass{article} usepackage{tikz} begin{document} begin{tikzpicture} foreach x in {-3,...,3} { draw(x,0.25) --(x,0)node[below]{x}; } foreach x in {-2.5,...,2.5} { draw(x,0.18) --(x,0); } draw[thick,<->](-3.5,0)--(3.5,0); filldraw[blue!50!white](1.5,0) circle (1mm); draw[red] (-3.5,-1) rectangle (3.5,1); % make bounding box higher end{tikzpicture} end{document} Only the first line of the tikzpicture environment is necessary. The rest is just to show that everything else is OK. I am...
Read more

Sun Ra

Image
.mw-parser-output .avviso .mbox-text-div>div,.mw-parser-output .avviso .mbox-text-full-div>div{font-size:90%}.mw-parser-output .avviso .mbox-image div{width:52px}.mw-parser-output .avviso .mbox-text-full-div .hide-when-compact{display:block} Questa voce o sezione sull'argomento compositori statunitensi non cita le fonti necessarie o quelle presenti sono insufficienti . Puoi migliorare questa voce aggiungendo citazioni da fonti attendibili secondo le linee guida sull'uso delle fonti. Sun Ra Sun Ra nel 1992 al conservatorio del New England Nazionalità   Stati Uniti Genere Fusion Free jazz Hard bop Space music Jazz d'avanguardia Musica sperimentale Big band Periodo di attività musicale 1934 – 1993 Strumento pianoforte, sintetizzatore Modifica dati su Wikidata  · Manuale .mw-parser-output .citazione-table{margin-bottom:.5em;font-size:95%}.mw-parser-output .citazione-table td{padding:0 1.2em 0 2.4em}.mw-parser-output...
Read more