Adding a two digit number in One Cell
 

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.

Adding a two digit number in One Cell
 

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


"Billy118" wrote in message
...
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.

Adding a two digit number in One Cell
 

Try this:

A1 = 16

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

--
Biff
Microsoft Excel MVP


"Billy118" wrote in message
...
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.