How to Count Repeated Words in Excel

In this Excel tutorial lesson, you will learn some trick - how to count repeated words. I implemented a word counter and would like to share it with you.

Counting words

There is a task. How to count repeated words in a cell?

For example, you have some words (e.g. aa) which repeat many times in one cell.

Counting Repeated Words in a Cell

How to count it?

Use that function:

=SUM(LEN(A1)-LEN(SUBSTITUTE(A1;"aa";"")))/LEN("aa")

Count Words in Cell

The Word Counter worked. There are 9 "aa" words. Counting Repeated Words in a Cell worked!