For example we have some word (e.g. aaa) which repeats many time in one cell.
How to count it?
Use that function:
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1;"aa";"")))/LEN("aa")
It works!
Please subscribe a blog. You will get to know how LEN and SUBSTITUTE functions work... and much more.
0 coms:
Post a Comment
Want something to write? You don't have to log in.