Pages in topic:   [1 2] >
Word count in Microsoft Excel?
Thread poster: transparx
transparx  Identity Verified
United States
Local time: 22:59
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!


Direct link Reply with quote
 
xxxF Schultze  Identity Verified
United States
Local time: 22:59
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.

Direct link Reply with quote
 
GKT  Identity Verified
Japan
Local time: 11:59
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


Direct link Reply with quote
 

Cilian O'Tuama
Local time: 04:59
German to English
+ ...
http://www.proz.com/post/305116 Jul 6, 2006

Check out this posting:

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


Direct link Reply with quote
 

Rosa Diez Tagarro  Identity Verified
Spain
Local time: 04:59
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


Direct link Reply with quote
 

Vito Smolej
Germany
Local time: 04:59
Member (2004)
English to Slovenian
+ ...
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.


Direct link Reply with quote
 
transparx  Identity Verified
United States
Local time: 22:59
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


Direct link Reply with quote
 

Orchtech
Local time: 04:59
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]


Direct link Reply with quote
 
Ryan Ginstrom
Local time: 11:59
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. 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]


Direct link Reply with quote
 

aiaccio  Identity Verified
Local time: 03:59
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

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


Direct link Reply with quote
 

John Jory  Identity Verified
Germany
Local time: 04:59
Member (2004)
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'.

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

Enjoy,

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


Direct link Reply with quote
 

John Jory  Identity Verified
Germany
Local time: 04:59
Member (2004)
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).

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

Enjoy,


Direct link Reply with quote
 
Andrew Kozlovsky  Identity Verified
Canada
Local time: 22:59
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!


Direct link Reply with quote
 

István Hirsch  Identity Verified
Local time: 04:59
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.


Direct link Reply with quote
 
jyxxer  Identity Verified
Australia
Local time: 12:59
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.


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






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs