| User | Thread poster: laila mostafa How to count words in .xls files without Trados |
|---|
laila mostafa
Egypt
Local time: 03:53
English to Arabic
+ ...
|
i got a job in xls format, is there a way toknow the word count without using trados
| | | |
Tom in London
United Kingdom
Local time: 02:53
 Member (2008)
Italian to English
|
laila mostafa wrote:
i got a job in xls format, is there a way toknow the word count without using trados |
|
File --> Properties ---> statistics
[Edited at 2011-12-12 10:08 GMT]
| | | |
laila mostafa
Egypt
Local time: 03:53
English to Arabic
+ ...
TOPIC STARTER |
well! thx. alot but could u tell me where to get it in office 2010
| | | |
Lisa Simpson, MCIL 
United Kingdom
Local time: 02:53
 Member (2010)
Portuguese to English
+ ...
|
Copy and paste the cells into Word and just use the word count function in Word.
| | | |
Extra Consult
Belgium
Local time: 03:53
 Member (2008)
English
| | Use LEN function | Dec 12, 2011 |
Hello,
Excel also features the =LEN function. If the text is in column A, you could put this in B1 to get the character count of cell A1:
=LEN(A1)
You can also trim spaces etc...you'll find more info on LEN here:
http://www.ozgrid.com/Excel/count-words.htm
Might be a bit much info, but once you get the hang of this, you won't need any other tools again to perform an excel wordcount
Geert
| | | |
Russell Jones
United Kingdom
Local time: 02:53
Member (2004)
Italian to English
MODERATOR | |
Vladimír Hoffman
Slovakia
Local time: 03:53
Member (2009)
Slovak to English
+ ...
| |
David Wright
Austria
Local time: 03:53
Member (2007)
German to English
+ ...
| | Not in office 2010 | Dec 12, 2011 |
To reply to your query to Tom, it's not in Office 2010, you find it in explorer, right clikc the file, click on properties, click on the tab file information (I'm guessing that, cos my version is German - Datei Info) and it's there. Not sure how accurate it is. A quick check between this system and the word count in word produced different figures, but not significantly so.
| | | |
John Fossey
Canada
Local time: 21:53
Member (2008)
French to English
|
Agree - the free version gives a quick count, although there are limitations about what you can print. But you can see all the data on the screen.
| | | |
Vladimír Hoffman
Slovakia
Local time: 03:53
Member (2009)
Slovak to English
+ ...
|
Nice method and nice to see a translator who uses Excel functions in his work. But I see some limitations of your method (higher number of columns, very high number of rows, table with merged cells and complicated structure).
What about trying this small macro:
Sub Makro_CountCells()
Dim NumOfChar As Single
Dim Area As Range
Set Area = Range(Cells(1, 1), Cells(1000, 50))
For Each Cell In Area.Cells
NumOfChar = NumOfChar + Len(Trim(Cell.Value))
Next
MsgBox NumOfChar
End Sub
The macro could be extended with user-defined areas instead of fixed one, but in the most cases it should be sufficient.
Best regards
Extra Consult wrote:
Hello,
Excel also features the =LEN function. If the text is in column A, you could put this in B1 to get the character count of cell A1:
=LEN(A1)
You can also trim spaces etc...you'll find more info on LEN here:
http://www.ozgrid.com/Excel/count-words.htm
Might be a bit much info, but once you get the hang of this, you won't need any other tools again to perform an excel wordcount
Geert |
|
[Edited at 2011-12-12 14:35 GMT]
|  |  |
| | | |
Vladimír Hoffman
Slovakia
Local time: 03:53
Member (2009)
Slovak to English
+ ...
| | Export possibility available? | Dec 12, 2011 |
I use it extensively when preparing lists of translated files for my clients (e.g. where a job consists of many small word or excel files), but I do not know if the function is also available in the free version. It has saved me a lot of time and nerves.
John Fossey wrote:
Agree - the free version gives a quick count, although there are limitations about what you can print. But you can see all the data on the screen. |
|
| | | |
listings
United States
Local time: 18:53
| |
The translation workplace 
