Add numbers in a cell

J

Jim

Can someone tell me how to add numbers is a cell? For example cell "A1" may contain the numbers 1232122211. I want to be able to add the numbers up, in this case = 17, thanks for your help....

Jim
 
D

DavidObeid

here is abit of a long winded though working solution

Enter the number whose digits you wantto add in cell A1


+----------------------------------------------------------------+
| Attachment filename: cellnumberadder.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=376416|
+----------------------------------------------------------------+
 
R

raymondsum

For my interest, how to amend the formula to include Letter?

eg A=1 , B=2, C=3 and so on Z=26

ie A123 equals to 7

Raymond
 
Top