count letters

[makinmomb]

Say i have this on A1

aa
b

Formula on b1 drag down to give me results

2
1

[Pete_UK]

Try this:

=LEN(A1)

This will give you the number of characters in the string in cell A1, whether they are letters, digits, punctuation symbols etc.

Hope this helps.

Pete