How do you count number of characters in a single cell

[Joe]

How do you count number of characters(tabular data) in a single cell?

 

[JE McGimpsey]

one way:

=LEN(A1)

which includes space characters, or

=LEN(SUBSTITUTE(A1," ",""))

which doesn't.