How To Get Word Count In Google Sheets - TechJunkie
FBTwitterReddit
video description
Rating: 4.0; Vote: 1
How To Get Word Count In Google Sheets - TechJunkie
Unlike most word processors, Sheets doesn-t have a word-counting tool that allows you to keep track of the number of words you-ve typed, but as with many of Sheet-s shortcomings, there is a workaround.
Formulas:
=COUNTA(SPLIT(A1, - -))
=ARRAYFORMULA(SUM(COUNTA(SPLIT(A1:A5, - -))))
=COUNTA(SPLIT(ARRAYFORMULA(CONCATENATE(A1:A&CHAR(32))),CHAR(32)))
koyashkay: surpsingly very last one worked for me (while nothing else I have tried worked so far), I just had to add -1 to it to get the exact number of words in a column Date: 2022-03-28
7:24
