xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Count the Number of Words in a Text String

Count the Number of Words in a Text String

The following formula counts the number of words in B2...

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

Based on the sample data, the formula returns 8.  Sample Workbook


spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes