CODEWITHSUNDEEP
excelexcel-formulaconcatenationvba
denmaster
denmaster

Reputation: 135

Excel formula to concantinate two cells containing sum formula

I have two cells with sum formula that is cell A = "=10+20" & cell B = "=3+20". I want to concatenate their formula in cell C as ="10+20+3+20". And I don't want to convert these cells into value. Requesting the teams helps please

Upvotes: 2

Views: 155

Answers (2)

Sash Sinha
Sash Sinha

Reputation: 22473

Try: 

=CONCATENATE(FORMULATEXT(A1),"+",RIGHT(FORMULATEXT(B1),LEN(FORMULATEXT(B1))-1))

Upvotes: 2

Forward Ed
Forward Ed

Reputation: 9894

=A1&"+"&right(B1,len(B1)-1)

The & is short form for concatenate. you need to add the + in between the contents of the two cells. It will display your formulas as a string. The right function will strip off the = sign from the B1 formula.

If your formulas in A and B are actually formulas displaying values as in the image below, then you want to use the following formula. It is set up for row 2. And hats off to Shash for giving light to this option 

=FORMULATEXT(A2)&"+"&RIGHT(FORMULATEXT(B2),LEN(FORMULATEXT(B2))-1)

Proof of Concept

enter image description here

Upvotes: 1

Related Questions