Select Page

Here is a quick solution for counting number of words in given cell. There is picture with example and belov is formula that you can paste into your Sheet, and just change cell that you want to count words.

Example for getting number of words in cell A2:
=IF(LEN(TRIM(A2))=0;0;LEN(TRIM(A2))-LEN(SUBSTITUTE(A2;” “;””))+1)