Results 1 to 7 of 7

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. #1
    Board Regular
    Join Date
    Oct 2002
    Posts
    130

    Default

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

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,993

    Default

    =len(a1)

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default

    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?
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    Board Regular
    Join Date
    Oct 2002
    Posts
    130

    Default

    Thanks! Paddy has answered my question. This site is great!

  5. #5
    New Member
    Join Date
    Jun 2013
    Posts
    2

    Default Re: What is the formula to count number of letters in a cell

    Quote Originally Posted by PaddyD View Post
    =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. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    WA state
    Posts
    360

    Default Re: What is the formula to count number of letters in a cell

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

  7. #7
    New Member
    Join Date
    Jun 2013
    Posts
    2

    Default Re: What is the formula to count number of letters in a cell

    Quote Originally Posted by Scott R View Post
    =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.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com