101Excel Hacks
    Back to Blog
    Excel formulasHack 80
    =LEN function
    =SUBSTITUTE function
    characters
    count
    Excel formula
    strings
    text analysis

    Count How Many Times a Character Appears Inside an Excel Cell

    Excel Hack #80

    12 views
    1 min read
    2021-07-23
    Count How Many Times a Character Appears Inside an Excel Cell

    This is a short and quick hack that could come in handy while conducting complex text analysis in MS Excel. If you needed to count the number of times a particular character, letter or string occurs w...

    This is a short and quick hack that could come in handy while conducting complex text analysis in MS Excel.

    If you needed to count the number of times a particular character, letter or string occurs within a cell (or a range of cells) in Excel, apply the formula below:

    =(LEN([cell])-LEN(SUBSTITUTE([cell], "[character or string]","")))/LEN("[character or string]")

    This is what it looks like in operation:

    Frequently Asked Questions