excel count how many times a character appears in a cell

The solution for this is noted below

excel count how many times a character appears in a cell

Solution

=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

Try other methods by searching on the site. That is if this doesn’t work