Pages in topic: [1 2] > | Word count in Microsoft Excel? Thread poster: transparx
| transparx United States Local time: 04:50 English to Italian + ...
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) United States Local time: 04:50 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 Japan Local time: 17:50 Member (2006) Japanese to French + ...
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 | | |
|
|
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 Germany Local time: 10:50 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 United States Local time: 04:50 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 Local time: 11:50 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) Local time: 17:50 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 Local time: 09:50 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 Germany Local time: 10:50 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 Germany Local time: 10:50 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 | |
|
|
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! | | | 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 Australia Local time: 18:50 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? TM-Town | 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 » |
| 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 » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |