Count number of words in excel

Many of us have come across one or other scenario where we sometime need to count or keep track of number of words in excel.

See below formulae how to do this.

=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1