Excel - How to count a letter's occurences within a Cell

December 2016


Can you please let me know if there is a way where a particular text string can be counted within a value of a cell itself.

For example: A cell contains AAAABBBCCCAAA and I need to calculate occurrences of alphabet 'A' in this particular cell.


This should do the trick:


To find alphabet "B" or any other character, replace the "A" with the appropriate letter, or reference it to another cell where you can store the letter you are looking for, e.g.


where B1 now contains "A", or "C", etc.


Thanks to WRL for this tip on the forum.

Related :

This document entitled « Excel - How to count a letter's occurences within a Cell » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.