if you are only concerned about the length of the cell try:
= len(a1) + len(a2) + len(a3) + len(a4)

hth

Carlo


On Nov 6, 10:44 am, Diego wrote:
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?