Add numbers in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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|
+----------------------------------------------------------------+
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Continuous Invoice Nos. 3
Excel How to add numbers in same cell? 2
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Add a cell to a fomula already in a cell and keep the formula 4
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Addition function of multiple cells 10
Excel Need Countifs Formula Help 0

Back
Top