I can't figure out the way of doing it. There is a note about it on microsoft
web site You can count the number of words in a cell by using the following
formula:

=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)

But it's not working. I can't even enter this formula since exell complains
every time that formula is not correct.

Any ideas?