Comptar 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)

via computerprogramming.suite101.com

El truc està en comptar els espais entre paraules.

Posted via web from jrosell's posterous