less than 1 minute read
There’s no built in way to count the number of words in Excel, but using the following formulas will get it done.
Download the example workbook here: Word Count.xlsx
Count the number of words in a cell
' A2 as the following sentence (without quotation marks) to get the word count:
' "Procrastination is the greatest labor saving invention of all time." =IF(LEN(TRIM(A2))0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(A2," ",""))+1)
Count the number of words in a range
Use an array formula to get the count of words in a range. Remember that array formulas need Ctrl+Shift+Enter to get the curly brackets {}.
' where the range is A2:A7 {SUM(IF(LEN(TRIM(A2:A7))0,0,LEN(TRIM(A2:A7))-LEN(SUBSTITUTE(A2:A7," ",""))+1))}
Tags: text
Categories: formulas
Updated: October 29, 2018