word count in Excel : is it possible, electronically?
Thread poster: NancyLynn

NancyLynn
Canada
Local time: 23:50
Member (2002)
French to English
+ ...

MODERATOR
Jul 17, 2004

Hi all,
I looked around but can't seem to find any info on the following: Is there some way to do a word count in Excel (Office XP) without the onerous task of counting manually? I have a series of long, long docs I need to invoice for. Any help is appreciated.

Nancy


 

Evert DELOOF-SYS  Identity Verified
Belgium
Local time: 05:50
Member
English to Dutch
+ ...
Practicount, Nancy! Jul 17, 2004

NancyLynn wrote:

Hi all,
I looked around but can't seem to find any info on the following: Is there some way to do a word count in Excel (Office XP) without the onerous task of counting manually? I have a series of long, long docs I need to invoice for. Any help is appreciated.

Nancy


Definitely works, at least for me.

Ciao, Evert


 

Henk Peelen  Identity Verified
Netherlands
Local time: 05:50
Member (2002)
German to Dutch
+ ...
copy to Word is a possibility Jul 17, 2004

Just
Ctrl + A
Ctrl + C
in he Excel file (one sheet a time) and
Ctrl + V
in the Word file, and you're able to use the standard Word word count.


 

Giuliana Buscaglione  Identity Verified
Austria
Local time: 05:50
Member (2001)
German to Italian
+ ...
You can use Trados as well Jul 17, 2004

Hi Nancy,

Apart from Practicount, you could also use Trados. Just open T-Window for Excel, then click on Tools ==> Analyse and add all files (you don't need to set up a project).

Giuliana


 

Michael Hesselnberg  Identity Verified
Local time: 05:50
French to German
+ ...
Look at this link, Nancy Jul 17, 2004

[quote]Giuliana Buscaglione wrote:

I never tried it for Excel but for PPT and Word, it's quite reliable for these files.
I guess that it's about 17 Euros for the Excel Word Count.
Look at it and tell us:

http://www.apluscounts.com/AplusCounts_EX_versions.html

HTH
Michael


 

Özden Arıkan  Identity Verified
Germany
Local time: 05:50
Member
English to Turkish
+ ...
Open it in Word and count Jul 17, 2004

All you need to do is

-start Word
-open your Excel file as a Word document, just as you open any other file in Word: click the File tab above, choose Open, and then choose your file in the window that pops up
-the program will prompt you whether to open the whole workbook or one or more sheets; choose whichever you want
-then count the words using Word's count tool, that's all!

HTH

Regards...

[Edited at 2004-07-17 22:17]


 

Amy Duncan  Identity Verified
Brazil
Local time: 00:50
Portuguese to English
+ ...
I can't open an Excel file in Word Jul 17, 2004

Xola wrote:

All you need to do is

-start Word
-open your Excel file as a Word document, just as you open any other file in Word: click the File tab above, choose Open, and then choose your file in the window that pops up
-the program will prompt you whether to open the whole workbook or one or more sheets; choose whichever you want
-then count the words using Word's count tool, that's all!

HTH

Regards...

[Edited at 2004-07-17 22:17]


If I open Word, then click on File and Open, only Word files appear, not Excel ones. How do you do this?


Amy


 

Özden Arıkan  Identity Verified
Germany
Local time: 05:50
Member
English to Turkish
+ ...
All files Jul 18, 2004

AmyD wrote:

If I open Word, then click on File and Open, only Word files appear, not Excel ones. How do you do this?


Amy



Please make sure "Files of type:..." below (in the File Open window) is set to "All files".

[Edited at 2004-07-18 03:12]


 

Sol  Identity Verified
United States
Local time: 23:50
Spanish to English
+ ...
use Trados' Analyze Jul 18, 2004

It counts words (and repetitions)in many different file formats.

 

sbirkelu
Local time: 05:50
English to Norwegian
+ ...
Export it to Word, perhaps? Jul 19, 2004

I don't know of any, but can't you somehow export it, for instance by cutting/pasting, to Word and count it there?

Regards
Sverre

NancyLynn wrote:

Hi all,
I looked around but can't seem to find any info on the following: Is there some way to do a word count in Excel (Office XP) without the onerous task of counting manually? I have a series of long, long docs I need to invoice for. Any help is appreciated.

Nancy


 

NancyLynn
Canada
Local time: 23:50
Member (2002)
French to English
+ ...

MODERATOR
TOPIC STARTER
Thanks everyone Jul 19, 2004

Good Monday morning all,

Thanks for your responses.

I couldn't use T-Window for Excel, for some reason I keep getting a 'format not recognised' message.

As for PractiCount, Evert, I've been eyeing it with a view to buy, but it's yet another expense in a year full of them for us - plus my husband recommends that I upgrade to Trados 6.5, another rather pricey item... and I still have to complete my bathroom, an unexpected event in our lives (both time & money, you know...)

But transferring the text to Word should work out. Thanks for dragging me out of my fog!icon_rolleyes.gif

Michael, I checked out the link you added, but again, 119 Euro is a little steep, I find.

OTOH, someone else reading this forum may decide it's just the thing.icon_wink.gif

Have a fun & productive week, everyone!

Nancy


 


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 Excel : is it possible, electronically?

Advanced search







SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



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