word count in excel

[jthamizhirai]

dear all

i would like to count the number of words in excel.

is there a function which i can use.

if i have to count in excel"this is a test"

how do i do it.thanks in advance

jay

 

[Hui]

Try:

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

 

[jthamizhirai]

thanks hui.wonderful and awesome.it works well.

jay

 

[Montrey]

nice formula Hui.