jrosell’s posterousComptar paraules a OpenOffice Calc i a Excel
Formula to Count Words in a Cell for Excel or Calc
With a few minor changes, the following will work equally well in either Excel or Calc spreadsheets.
=IF(LEN(TRIM(A1))=0;0;LEN(TRIM(A1))-LEN(SUBSTITUTE(A1;" ";""))+1)
El truc està en comptar els espais entre paraules.
