Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Returns the number of words

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