Word counting in Excel files
Thread poster: Gitte Gifford

Gitte Gifford
Local time: 22:55
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


 

Elvira Stoianov  Identity Verified
Luxembourg
Local time: 22:55
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.

 

Edward Potter  Identity Verified
Spain
Local time: 22:55
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.


 

Özden Arıkan  Identity Verified
Germany
Local time: 22:55
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!
icon_wink.gif



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]


 

Tsu Dho Nimh
Local time: 14:55
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!
icon_wink.gif



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.


 

Uldis Liepkalns  Identity Verified
Latvia
Local time: 23:55
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.


 

Erick Forero  Identity Verified
Local time: 15:55
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!
icon_wink.gif



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]


 

Özden Arıkan  Identity Verified
Germany
Local time: 22:55
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.

Regardsicon_smile.gif


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


 

Rolf Kern  Identity Verified
Switzerland
Local time: 22:55
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


 

Rolf Kern  Identity Verified
Switzerland
Local time: 22:55
English to German
+ ...
Use TextCount Jul 22, 2005

See www.textcount.de

Regards
Rolf Kern


 


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







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 »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



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