Pages in topic:   < [1 2]
Word count in Microsoft Excel?
Thread poster: transparx

Tjasa Kuerpick  Identity Verified
Local time: 10:17
Member (2006)
Slovenian to German
+ ...

Wörter zählen (wenn die Excel Funktionsbefehle in Deutsch sind):

count words (if the Excel function commands are in English):
=LEN(A1)-LEN(SUBSTITUTE(A1;" ";""))+1

Note: You have to put the formula in the cell A2.
If you want to count the words in another cell, e.g. B19 insert B19 in the formula.
To count down the whole colum, click on the cell with the formula and pull down the cell.
That’s it!

[Edited at 2012-12-27 09:08 GMT]

Direct link Reply with quote

Javier Tomás  Identity Verified
Local time: 10:17
Member (2013)
English to Spanish
+ ...
A dead-straight way to count words in Excel Apr 15, 2013

István Hirsch wrote:

If the text is trimmed (only one space between the words), press Ctrl + H (Replace), „replace” space with space, click Replace All and read the number of changes, add one.

This seems to me to be by far the simplest, most elegant way of counting words in Excel, without any copy-pasting, scripting or program-installing. There is one change to be made, though (step 3 below). The process would go on as follows:

1. Select the relevant cells.
2. Replace space by space and notice how many replacements have been made.
3. Add to that number the number of cells involved...

et voilà!

Direct link Reply with quote
United States
Thanks! Lifesaver Sep 7, 2013

Andrew Kozlovsky wrote:

Orchtech wrote:

to count the words of a text in an Excel cell use this equation.

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

where D2 is the Cell where the text exists

Kind Regards,
Omar Shafik

[Edited at 2008-05-26 12:42]



Thank you this worked perfectly.

Direct link Reply with quote

Ricardo Robina  Identity Verified
Local time: 03:17
English to Spanish
+ ...
Nifty prog Oct 23, 2013

John Jory wrote:

The problem with the wordcount in Word (and the macro provided above) is that numbers as well as characters such as '=' are counted as words.

FineCount is free, and works fine. Especially useful is that it also grabs the words in textboxes in MS Word (which are ignored by the embedded MS Word function).
It also distinguishes between 'Words only' and 'Words + numbers'.

Here's the link:


[Edited at 2009-05-27 15:24 GMT]

Nifty prog! Works for lots of formats. I like how it creates invoices and reports as well.

Direct link Reply with quote
AnnaEbner  Identity Verified
United States
Local time: 03:17
Member (2014)
Spanish to English
Thank you so much!!! May 16, 2014


Thank you so much for the information. I know this post is outdated, but I have a HUGE excel document I am translating with several (dozens) spreadsheets, and the Count Anything program is quick and easy to install, and very easy to use. It's as easy as drag-and-drop!!!

Thanks again,

Anna E.

Direct link Reply with quote

Balasubramaniam L.  Identity Verified
Local time: 13:47
Member (2006)
English to Hindi
+ ...
Using Trados Jun 13, 2015

Load the excel file into a Trados project and prepare it for translation. The word count will be displayed in the statistics available in the Reports tab, which will also give fuzzy details of the text.

Direct link Reply with quote
Charlie Delta
An easier way of word count in Excel Jul 14, 2015

GKT wrote:

ninogulli wrote:

Does Microsoft Excel have a word-count function? If it does, I don't seem to be able to find it.
Any help would be greatly appreciated!

I am not aware of any word-count function in Excel.

However, here is a trick you might want to try when you have to count words (or characters) in an Excel file:

1) Open the file
2) Save it in unicode text format (*.txt).
3) Open it with Word
4) Use the word-count function of word. Et voila!

I hope this helps


Or you can just copy and paste the text from Excel to Word, one or more columns or rows.

Direct link Reply with quote

United States
Local time: 03:17
Spanish to English
+ ...
Excel Word Count for Mac May 18

I know this is an old thread but still relevant. I always copy and paste to Word and do a word count, but this file has 37 tabs!!! When I copied and pasted into Word, it was chaos and it shows many more words than what I think... So, in order to be fair to my client, I wanted to use something else, but cannot come up with any of these options above because they do not work for Mac. Anyone out there discover anything new? Thanks.

Direct link Reply with quote
Pages in topic:   < [1 2]

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Word count in Microsoft Excel?

Advanced search

Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search