Mobile menu

Word counting in Excel files
Thread poster: Gitte Gifford
Gitte Gifford
Local time: 17:31
English to Danish
+ ...
Jul 14, 2005

Dear all,

Would any of you please explain me how a total word count is carried out in Excel files?

Thanks a lot!

BR
Gitte Hoejland


Direct link Reply with quote
 

Elvira Stoianov  Identity Verified
Luxembourg
Local time: 17:31
German to Romanian
+ ...
Trados or copy text to Word Jul 14, 2005

You can run a Trados analysis (might take a few minutes, depending on file size) or you can copy the entire text to Word.

Direct link Reply with quote
 

Edward Potter  Identity Verified
Local time: 17:31
Member (2003)
Spanish to English
+ ...
Counting Excel words Jul 14, 2005

I just had this issue the other day:
http://www.proz.com/topic/34552

I did not know that Trados could analyze Excel tables. I could not find a way for WordFast to do it. I ended up copying and pasting everything into Word, then analyzing my new file.

This is not an ideal way of doing it because it is all too easy to miss highlighting data or skip over sheets 2, 3 and 4 by forgetting to click their tabs.

I'm still looking for a 3-click solution for analyzing 25 Excel files.


Direct link Reply with quote
 

Özden Arıkan  Identity Verified
Germany
Local time: 17:31
Member
English to Turkish
No need to copy-paste Jul 15, 2005

Start the Word program, and open the Excel file from within that program, open it as a Word file, that is. Then, Tools -> Word Count OR WordFast -> Analyse!




Edward Potter wrote:

I just had this issue the other day:
http://www.proz.com/topic/34552

I did not know that Trados could analyze Excel tables. I could not find a way for WordFast to do it. I ended up copying and pasting everything into Word, then analyzing my new file.

This is not an ideal way of doing it because it is all too easy to miss highlighting data or skip over sheets 2, 3 and 4 by forgetting to click their tabs.

I'm still looking for a 3-click solution for analyzing 25 Excel files.


[Edited at 2005-07-15 01:12]


Direct link Reply with quote
 
Tsu Dho Nimh
Local time: 09:31
English
What version of Word? Jul 18, 2005

Xola wrote:

Start the Word program, and open the Excel file from within that program, open it as a Word file, that is. Then, Tools -> Word Count OR WordFast -> Analyse!




Which version of Microsoft Word are you doing that with? And are you opening .XLS files (Excel's format) or CSV files (generic spreadsheet interchange format)

I can open an Excel file from within Word, but using Office 2003 I get gibberish.


Direct link Reply with quote
 

Uldis Liepkalns  Identity Verified
Latvia
Local time: 18:31
Member (2003)
English to Latvian
+ ...
Download Practicount Jul 18, 2005

from
http://www.practiline.com/
It will be fully functional for 15 days.
And if you like it, you can buy it after. I use Practicount for last few years and am fully satisfied.

Uldis

Edward Potter wrote:
I'm still looking for a 3-click solution for analyzing 25 Excel files.


Direct link Reply with quote
 
Erick Forero  Identity Verified
Local time: 11:31
English to Spanish
Word 2003 Jul 19, 2005

Hi all,

I tried doing that in Word 2003 but could not get the right format to make the Excel file "readable" in Word. Xola, could you please send further explanation?

Thanks a lot!

Erick



Xola wrote:

Start the Word program, and open the Excel file from within that program, open it as a Word file, that is. Then, Tools -> Word Count OR WordFast -> Analyse!




Edward Potter wrote:

I just had this issue the other day:
http://www.proz.com/topic/34552

I did not know that Trados could analyze Excel tables. I could not find a way for WordFast to do it. I ended up copying and pasting everything into Word, then analyzing my new file.

This is not an ideal way of doing it because it is all too easy to miss highlighting data or skip over sheets 2, 3 and 4 by forgetting to click their tabs.

I'm still looking for a 3-click solution for analyzing 25 Excel files.


[Edited at 2005-07-15 01:12]


Direct link Reply with quote
 

Özden Arıkan  Identity Verified
Germany
Local time: 17:31
Member
English to Turkish
Office 2000 Jul 20, 2005

Hi all,

I use Office 2000, so it should work even better with Office 2003. When you click open on an Excel file in Word, first an encoding window is shown where you make your choice. Then, in the beginning of the Excel file you might have some gibberish codes, small squares, signs etc., all over the place, just clean pass them, and further down starts your document. I work into Turkish, by the way, and two characters -peculiar to our alphabet- always display in a corrupted way, so I correct them with Ctrl+H and proceed with my work. That doesn't take me more than a few minutes to clear, anyway, and since I never feel at home with xls format, I much prefer to give a few minutes to be able to work on Word, even without any CAT.

Hope this would be of help.

Regards


ErickFG wrote:

Hi all,

I tried doing that in Word 2003 but could not get the right format to make the Excel file "readable" in Word. Xola, could you please send further explanation?

Thanks a lot!

Erick


Direct link Reply with quote
 

Rolf Kern  Identity Verified
Switzerland
Local time: 17:31
Member (2008)
English to German
+ ...
Use TextCount Jul 21, 2005

There is a very comfortable and cheap software available from
(free test edition avaialable!). It counts Word 2000+, Excel 2000+ etc.

Rolf


Direct link Reply with quote
 

Rolf Kern  Identity Verified
Switzerland
Local time: 17:31
Member (2008)
English to German
+ ...
Use TextCount Jul 22, 2005

See www.textcount.de

Regards
Rolf Kern


Direct link Reply with quote
 


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


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

Word counting in Excel files

Advanced search


Translation news





Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
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 »



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