Word Count From Cells

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))}