Pensar Blog

How to count the number of words in an Excel cell

Written by Mark Williams | 27 July 2016

Over the next few months we'll be running a series of blog posts giving marketing agencies quick, helpful advice so they can overcome some of the most common technology problems they face. We've been working with marketing agencies since day one, so we know the kind of problems they have and we have a few hacks up our sleeves to help out. Here's the first.

Tech hacks for marketing agencies #1

Excel is hardly the most convenient writing tool available for marketers, yet some clients insist that you write their content in this format.

Oh well: the customer is always right, even when they're not. There are many ways to make word processing better in Excel, this is one of the most helpful ones.

Want to count the number of words in an Excel cell? If you've written in cell A1, just post this formula in another cell:

=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)

It should look like the image below. As you can see, the green arrow points to the formula you need to enter, and the blue arrow shows the resulting calculation.

If you've written your text in another cell, just substitute the references to A1 with the name of the cell you've written in.

Sorted. Solving for the client made easy.