How to show/insert numbers inside sum function ?

Question

Hey Microsoft community,Is there anyway that we can do the below example :If i have already wrote sum function =1+2+3&nbsp;I wanna insert 4+5 inside the formula&nbsp; like below shown :Actually i have around 500 row and i can't do it manually ,it will take so much time .&nbsp;Appreciate your kind support .&nbsp;&nbsp;

riny_van_eekelen · Answer

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-showinsert-numbers-inside-sum-function/a2097d19-3b83-4548-9ba3-c846adc9f4ae

m_tarler · Answer

alternatively you can use a formula to create the text string:

=TEXTJOIN("+",,H2:J2)

that will produce 4+5 text and then copy and paste special (as value) in another cell

here is where it can get funky, for some reason in some cases excel will automatically convert it back to a 'regular' formula copy and become "=TEXTJOIN("+",,H3:J3)"

That said, if that happens, just hit UNDO and the cell will revert back to the 4+5 text only

Finally copy that text into your equation.

Forum Discussion

How to show/insert numbers inside sum function ?

2 Replies

Resources