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

NancyLynn
Canada
Local time: 14:55
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: 20:55
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: 20:55
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
United States
Local time: 11:55
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 (X)  Identity Verified
Local time: 20:55
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: 20:55
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 (X)  Identity Verified
Brazil
Local time: 15:55
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: 20:55
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: 14:55
Spanish to English
+ ...
use Trados' Analyze Jul 18, 2004

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

 

sbirkelu
Local time: 20:55
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: 14:55
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







WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

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 »



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