Adding a two digit number in One Cell

[Billy118]

Is there any way I can add the two digits making up example: the number 16
which is found in a single cell. Add 1 plus 6 which would equal 7. The
original number 16 is the number found in a single cell.

 

[Rich/rerat]

In A1: 16
In B1: =SUM(RIGHT($A1,1),LEFT($A1,1))
Drag formula down if you want to do this to multiple entries in Column A.
--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat (RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


Is there any way I can add the two digits making up example: the number 16
which is found in a single cell. Add 1 plus 6 which would equal 7. The
original number 16 is the number found in a single cell.

 

[T. Valko]

Try this:

A1 = 16

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