EXCEL: wordcount within cell

[CPAZO]

How do i set up wordcount within cell?

 

[Mike H]

Try

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

Mike

 

[Teethless mama]

=LEN(A1)

 

[Dave Peterson]

If the words are separated by spaces:
=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<>"")

 

[John C]

And if I have 2 words in the cell?

Borrowing from Mike's solutions:
=IF(A1="",0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1)