View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Diego Diego is offline
external usenet poster
 
Posts: 2
Default EXCEL: how do I add multiple one digits in a singe cell? (tally)

Subject: Tallying e.g. 111=3
How do I make a single cell add three 1s?

Cell A1 has 11
Cell A2 has 111
Cell A3 has 1
Cell A4 has 1111

How do I get the sheet to create a total of 10?