ufwish.blogg.se

Highlight the blank cell where you want to display your results and paste the following formula: =IF(A2=””,””,COUNTA(SPLIT(A2,” “))) where “ A2” specifies the cell to be counted.To preview word counts per cell with some cells being empty within your specified range, use the following instructions. Option #2: Word Count per Cell with Empty Cells in Specified Range A2 translates to Column, Row Number where “ A” is the column and “ 2” is the row number, which totals the word count in the specified cell.SPLIT counts everything separated by a space as an individual point of data (your content can be counted as a word, even if it’s just a number).COUNTA auto-counts the words in the cell.Here is the breakdown of the formula used, which was “ =COUNTA(SPLIT(A3, ” “)).” Click in your display cell or hit Enter to apply the formula.Īs you can see above, cell A3 has two words.Highlight the blank cell where you want to display your results and paste the following formula: =COUNTA(SPLIT(A3, ” “) ) where “ A3” specifies the cell.