View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 39
Default 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.