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.