Counting Repeated Words in a Cell

In this lesson you can learn some trick - how to count repeated words.

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

For example you have some word (e.g. aa) which repeats many time 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

It works!