Pages in topic:   [1 2] >
Word count in Microsoft Excel?
Thread poster: transparx
transparx
transparx  Identity Verified
United States
Local time: 05:23
English to Italian
+ ...
Jul 6, 2006

Hi,
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!


 
F Schultze (X)
F Schultze (X)  Identity Verified
United States
Local time: 05:23
Danish to English
+ ...
I save as .txt file and have Word count the words Jul 6, 2006

Somewhat cumbersome, but it works. I do the same with MS Access files.

 
GKT
GKT  Identity Verified
Japan
Local time: 18:23
Member (2006)
Japanese to French
+ ...
Just a trick Jul 6, 2006

ninogulli wrote:

Hi,
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

GKT


 
Cilian O'Tuama
Cilian O'Tuama  Identity Verified
Germany
Local time: 10:23
German to English
+ ...
http://www.proz.com/post/305116 Jul 6, 2006

Check out this posting:

http://www.proz.com/post/305116


 
Rosa Diez Tagarro
Rosa Diez Tagarro  Identity Verified
Spain
Local time: 10:23
Member (2003)
English to Spanish
+ ...
use the trick if you don't want to invest ;) Jul 6, 2006

If you're not interested in buying any software, the trick does the job (it's what I do, BTW).

Regards,

Rosa


 
Vito Smolej
Vito Smolej
Germany
Local time: 10:23
Member (2004)
English to Slovenian
+ ...
SITE LOCALIZER
You dont even have to save a file ... Jul 6, 2006

select all in Excel, copy it and then paste it into Word.

Do that for all spreadsheets.

What you do not get this way are (among other things) the comments in cells.


 
transparx
transparx  Identity Verified
United States
Local time: 05:23
English to Italian
+ ...
TOPIC STARTER
thanks to all! Jul 6, 2006

GKT wrote:

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

GKT


I'd like to thank everyone.

I found this method to be the best.
NG


 
Orchtech
Orchtech
Local time: 11:23
English to Arabic
+ ...
Using Word Count in Excel May 24, 2008

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]


 
Ryan Ginstrom (X)
Ryan Ginstrom (X)
Local time: 18:23
Japanese to English
Free program that counts words in Excel files May 4, 2009

This thread is quite old, but it comes up fairly high in the search engines, so I thought I'd respond for the record.

I have a free program that will count words in Microsoft Excel and several other types of files: Count Anything.

Saving the file as text and then counting that has a couple of problems. Firstly, you can only save one worksheet at a time this way. Second
... See more
This thread is quite old, but it comes up fairly high in the search engines, so I thought I'd respond for the record.

I have a free program that will count words in Microsoft Excel and several other types of files: Count Anything.

Saving the file as text and then counting that has a couple of problems. Firstly, you can only save one worksheet at a time this way. Secondly, I don't believe that this saves the text in text boxes and the like.

Count Anything will count the words in all worksheets, including text boxes. You can also count more than one file at once. It's free, so it might be worth checking out if you're looking for a good way to count words in Excel files.



[Edited at 2009-05-04 04:11 GMT]
Collapse


 
aiaccio
aiaccio  Identity Verified
Local time: 09:23
English to Italian
VBA Macro in Excel to calculate wordcount in a range of cells May 27, 2009

Here is a VBA Macro to count number of words in Excel: once the macro is set up, it is possible to count the words simply selecting the range of cells and running the Macro (you can apply a shortcut to it to make it quicker).

Just need to copy the below "script" in the macro editor:

Sub CountWords()
Dim MyRange As Range
Dim CellCount As Long
Dim TotalWords As Long
Dim NumWords As Integer
Dim Raw As String

... See more
Here is a VBA Macro to count number of words in Excel: once the macro is set up, it is possible to count the words simply selecting the range of cells and running the Macro (you can apply a shortcut to it to make it quicker).

Just need to copy the below "script" in the macro editor:

Sub CountWords()
Dim MyRange As Range
Dim CellCount As Long
Dim TotalWords As Long
Dim NumWords As Integer
Dim Raw As String

Set MyRange = ActiveSheet.Range(ActiveWindow.Selection.Address)
TotalWords = 0
For CellCount = 1 To MyRange.Cells.Count
If Not MyRange.Cells(CellCount).HasFormula Then
Raw = MyRange.Cells(CellCount).Value
Raw = Trim(Raw)
If Len(Raw) > 0 Then
NumWords = 1
Else
NumWords = 0
End If
While InStr(Raw, " ") > 0
Raw = Mid(Raw, InStr(Raw, " "))
Raw = Trim(Raw)
NumWords = NumWords + 1
Wend
TotalWords = TotalWords + NumWords
End If
Next CellCount
MsgBox "There are " & TotalWords & " words in the selection."
End Sub

I found it quite useful and first of all FREE
Collapse


 
John Jory
John Jory  Identity Verified
Germany
Local time: 10:23
English to German
+ ...
Use FineCount May 27, 2009

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'.

... See more
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: http://www.tilti.com/tilti-com.software.finecount?pc_code=&ver=

Enjoy,

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


 
John Jory
John Jory  Identity Verified
Germany
Local time: 10:23
English to German
+ ...
Use FineCount May 27, 2009

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 M
... See more
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).

Here's the link: http://www.tilti.com/tilti-com.software.finecount?pc_code=&ver=

Enjoy,
Collapse


 
Andrew Kozlovsky
Andrew Kozlovsky  Identity Verified
Canada
Local time: 05:23
English to Russian
+ ...
this works really cool! Sep 16, 2010

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]


Thanks!


 
István Hirsch
István Hirsch  Identity Verified
Local time: 10:23
English to Hungarian
Another method in Excel Sep 17, 2010

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.

If not, and the text to count is in cell A1, before doing that, write in B1: =TRIM(A1), press Enter, then click on B1, Copy (toolbar), Paste arrow (toolbar ), select „Value” from the drop-down menu, then select column B.


 
jyxxer
jyxxer  Identity Verified
Australia
Local time: 20:23
French to English
+ ...
Word count in Excel + more Oct 24, 2011

In the interests of getting a word count in an Excel text file, I found that you can convert the Excel to PDF format (from the Excel tool bar), then scan that PDF into Word.

I found that most all formatting was preserved, plus I could edit and translate that file as a Word entity; word count is then a given.

Hope that helps.


 
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?






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »