Counting Repeated Words in a Cell

In this lesson you can learn some trick – how to count repeated words. I implemented word counter and would like to share it with you. 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

Word counter worked. There are 9 “aa” words Counting Repeated Words in a Cell worked!

Template

You can download the Template here – Download