=len(a1)
This is a discussion on What is the formula to count number of letters in a cell within the Excel Questions forums, part of the Question Forums category; What is the formula to count the number of alphabets in a cell?...
What is the formula to count the number of alphabets in a cell?
=len(a1)
Hi Dorothychin:
Paddy's formula will give you count of all the characters in the cell.
Should we read your question as Paddy did -- or did you have something else in mind such as count the number of only alpha characters in a cell that contains alphanumeric characters?
Thanks! Paddy has answered my question. This site is great!
=len(substitute(a1," ",""))
Like this thread? Share it with others