Excel Word Count

[Jon Capuchino]

Is there a way to perform a word count on a single cell? I have not see
a function that will do this.

I have hundreds of cells that need to be counted.

Thanks,

Jon
Austin, Texa

 

[Jesse Wiggins]

The LEN function counts characters, however, I am not aware of a function to
count words. Looks like you get to VB.

-Jesse

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Dan E]

Jon,

This may not be the best way but you can try it out.

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

Actually counts the number of spaces and adds 1 (assumes
that you don't start or end with a space.

Dan E

 

[Ture Magnusson]

Jon,

This formula counts the number of words in cell A1

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

This array formula (press Ctrl+Shift+Enter after typing it) counts the
number of words in the range A1:B10

=SUM(LEN(TRIM(A1:B10))-LEN(SUBSTITUTE(TRIM(A1:B10),"
",""))+1-ISBLANK(A1:B10))