Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Counting the number of individual letters in a word - Excel

  • 23-09-2007 08:12PM
    #1
    Trotter
    Closed Accounts Posts: 5,362 ✭✭✭


    Can anyone solve this little formula problem I'm having in Excel?

    Basically I want to count the number of letters in a string. So.. for example

    If I have the letters A B C A B C A B in a cell,

    I want to be able to have the following in a summary sheet
    A 3
    B 3
    C 2

    Some sort of count formula would do it. Trouble is, If I need to be able to count the number of characters in a cell, i.e. more than one.

    If I wrote the word 'abacus' in the cell, the formula would return

    a 2
    b 1
    c 1
    u 1
    s 1


    Basically Im trying to design a classroom management excel sheet.
    So.. If Student 1 is late (L) and has no homework done (H) , the cell for that day beside the Student 1's name would have L H in it, and the summary sheet would show:

    Student No. 1
    Homework Issues 1
    Days Late 1


    Am I making any sense? :D


Advertisement