How to count the number of words in an Excel cell

27 July 2016 by Mark Williams

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.

How to count the number of words in an Excel cell. Image shows the formula you need to use to count the number of words in an Excel cell.

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.

New Call-to-action

Save

Save

Save

Download Pensar's business guide to ransomware

Free email updates

Get useful business IT articles in your inbox as soon as they are published. No spam.
Unsubscribe at any time.