Hi everyone
I'd like to be able to see how many words are in each column in a Numbers sheet.
Is this possible at all?
If, as I suspect, it isn't: can anyone suggest a work around?
Many thanks in advance,
David
Mac mini, macOS 12.6
With the newer functions REGEX.EXTRACT and TEXTJOIN, along with COUNTA, it can be done.
D2=COUNTA(REGEX.EXTRACT(TEXTJOIN(" ",TRUE,B2:B6),"\S+",0))
It counts the number of groups of "non-whitespace" characters such as "The", "quick", "dog.", "ain't" etc.
With the newer functions REGEX.EXTRACT and TEXTJOIN, along with COUNTA, it can be done.
D2=COUNTA(REGEX.EXTRACT(TEXTJOIN(" ",TRUE,B2:B6),"\S+",0))
It counts the number of groups of "non-whitespace" characters such as "The", "quick", "dog.", "ain't" etc.
one method I have used on comment cells is to take the length of the cell, subtract the length after removing the spaces (add one for the first word)
would this work in your case?
…take the length of the cell, subtract the length after removing the spaces…
Clever!!!
Regards,
Barry
Word Count of text in a Numbers column?
