Forum Discussion
Counting words in cells with multiple words
In a survey analysis in Excel, I am trying to count unique words in cells with multiple text values per cell. I found the formula =SOM(LENGTE(A2:A7)-LENGTE(SUBSTITUEREN(A2:A7;"apple";"")))/LENGTE("ap...
I found this Excel Word Counter by accident, and it’s a gem! Just upload your file, and it takes care of the word count for you. Easy and efficient. https://pdfwordcounter.io/excel-word-counter/