# Word Count From Cells

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