Concatenate not doing what I want it to

[Tommy Layton]

Hello everyone, I am new here. I hope you are all well.

I am having a very hard time getting the Concatenate
formula, to do what I want it to... and most likely
it is because I am using the wrong formula.

Here is my problem...
If A1 reads
=200+100+10

and B1 reads
100

I would like a Formula to make C1 read as
=200+100+10+100

If I put a Concatenate formula into C1 it reads as
=CONCATENATE(A1+B1)

It shows the sum just fine... but none of the
history of the equation.

Does anyone know a formula that can maintain the
structure of the equation history while adding to it?

BTW this is for thousands of rows... not just one.

Thank you!!!

 

[jfish1288]

Not entirely sure what you are asking. Does A1 read "=200+100+10" or "310"? And do you want C1 to read "=200+100+10+100" or "450"?

 

[Tommy Layton]

Not entirely sure what you are asking. Does A1 read "=200+100+10" or "310"? And do you want C1 to read "=200+100+10+100" or "450"?

Hello Jfish, and thank you for your reply.

Sorry for not clarifying in greater detail.

A1 would show as 310, but upon hitting F2 would read =200+100+10

Also, my absolute end goal would be to have C2 show as 410
but upon hitting F2 have it read =200+100+10+100

Thank you

 

[MrVillareal]

Maybe you are trying to add manually instead of autosum.