Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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