Character count in Numbers cells

Another way to do it that would also count characters other than a-z,A-Z, and 0-9 would be to to subtract the number of "white space" characters from the total number of characters. That would take into account non-english letters (including those with tildes and umlauts), hyphens, symbols, etc. I wasn't thinking about those characters yesterday.

=LEN(B2)−COUNTMATCHES(B2,REGEX("\s"))

=COUNTMATCHES(B2,REGEX("\w"))

will give the count of all letters and digits, ignoring spaces, tabs, carriage returns, punctuation, etc.

LENgth will give you that information:

Regards,

Barry