Count words on Excel cells

spiros

  • Administrator
  • Hero Member
  • *****
    • Posts: 823143
    • Gender:Male
  • point d’amour
Count words on Excel cells

Let's suppose text is in column A
In any other column, first cell, we paste and drag the following:

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

Or this one if it throws an error:

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


 

Search Tools