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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Counting the number of individual letters in a word - Excel

  • 23-09-2007 7: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