Comptar paraules a OpenOffice Calc i a Excel

By jrosell | Published: 16 març 2010

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

This entry was posted in General. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • culturacat.com

  • esportscat.com