# What is the formula to count number of letters in a cell

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?...

1. What is the formula to count the number of alphabets in a cell?

2. =len(a1)

3. 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?

5. ## Re: What is the formula to count number of letters in a cell

=len(a1)
What if I wanted to count all the alphanumerics but did not want to count any spaces?
i.e. ignore space in count.

6. ## Re: What is the formula to count number of letters in a cell

=len(substitute(a1," ",""))

7. ## Re: What is the formula to count number of letters in a cell

Originally Posted by Scott R
=len(substitute(a1," ",""))
That is Awesome!!!
Great help for pricing signs!

How ridiculous would it be to get it to count lower case vs. upper case?
Numbers could be considered uppercase too.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•