Addition of 2 digit numbers in a cell

[Bub1967]

If you have a 2 digit number(i.e., 12) in a particular cell, how can you add those 2 numbers together(as 3 is the result), and insert that total in another cell. Thank you...

 

[VoG]

One way

=LEFT(A1,1)+RIGHT(A1,1)

 

[Bub1967]

Thank you VOG...I will try that!!

 

[Bub1967]

Tried it.....works great...thanks again!

 

[VoG]

ADVERTISEMENT

You are welcome.

To sum more than two digits see http://support.microsoft.com/kb/214053

 

[Peter_SSs]

Also, DonkeyOte has suggested a non-volatile formula here

 

[bosco_yip]

Sum digits (more than one) of a number

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

Regards

 

[Peter_SSs]

Sum digits (more than one) of a number

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

Regards

Agreed it works, but this, along with the Microsoft suggestion, is volatile. Would there be a reason to use this over the apparently non-volatile suggestion of DonkeyOte?