Mobile menu

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

NancyLynn
Canada
Local time: 12:44
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


Direct link Reply with quote
 

Evert DELOOF-SYS  Identity Verified
Belgium
Local time: 18:44
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


Direct link Reply with quote
 

Henk Peelen  Identity Verified
Netherlands
Local time: 18:44
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.


Direct link Reply with quote
 

Giuliana Buscaglione  Identity Verified
Austria
Local time: 18:44
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


Direct link Reply with quote
 
Michael Hesselnberg  Identity Verified
Local time: 18:44
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


Direct link Reply with quote
 

Özden Arıkan  Identity Verified
Germany
Local time: 18:44
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]


Direct link Reply with quote
 
Amy Duncan  Identity Verified
Brazil
Local time: 13:44
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


Direct link Reply with quote
 

Özden Arıkan  Identity Verified
Germany
Local time: 18:44
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]


Direct link Reply with quote
 

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

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

Direct link Reply with quote
 
sbirkelu
Local time: 18:44
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


Direct link Reply with quote
 

NancyLynn
Canada
Local time: 12:44
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!

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.

Have a fun & productive week, everyone!

Nancy


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

Advanced search


Translation news





SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



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