count digits within cell

[Guest]

I want to create a forumula in B1 that will sum up how many letters I have
entered into A1. There will never be more than five digits in A1. I frankly
don't know where to begin.

example: A1 = MTW

 

[Guest]

Try:
=len(a1)

 

[Guest]

Thanks!

Try:
=len(a1)

 

[Guest]

Hi
You may also try LEN(TRIM(A1)) which will count the characters without any
trailing spaces that may have been inadvertantly left in the cell.

 

[Dave Peterson]

=trim() also cleans up leading/trailing and multiple internal spaces, too.