Counting Repeated Words in a Cell
How to count it?
Use that function:
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1;”aa”;””)))/LEN(“aa”)
Word counter worked. There are 9 “aa” words Counting Repeated Words in a Cell worked!
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
