Shaun Wingrin
asked on
Word Count Google Sheets
In Column A, I have got an English sentence. In Column B, I'd like to get a Word Count of Column A. Is there a Simple formula or method to do this? Please provide simple instructions for a novice in Google sheets, thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found what we were looking for, in this alternative formula: =if(A1="","",counta(split( A1," "))) . Substitute "A1" for the cell in which you want to calculate the number of words. Here is the link to the answer found in Google product forums : https://productforums.google.com/forum/#!topic/docs/FMxJRxDNI1E
ASKER