Excel Word Count

  • Thread starter Thread starter Jon Capuchino
  • Start date Start date
J

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
 
The LEN function counts characters, however, I am not aware of a function to
count words. Looks like you get to VB.

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

HTH
Jason
Atlanta, GA
 
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
 
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))
 
Back
Top