Counting occurences of a character in a spreadsheet

In this Excel tutorial you will teach yourself how to count occurences of a character in a spreadsheet.

Let's count how many of f character do you have in a A coulmn. To do that just use below formula:

=SUM(LEN(A:A)-LEN(SUBSTITUTE(A:A;"f";"")))

This is an array formula so remember to press CTRL + SHIFT + ENTER combination.

Counting character occurences