Translation - art & business » Business issues »
word count in Excel : is it possible, electronically?
Thread poster: NancyLynn
NancyLynn
NancyLynn
Canada
Local time: 08:04
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
Evert DELOOF-SYS  Identity Verified
Belgium
Local time: 14:04
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
Henk Peelen  Identity Verified
Netherlands
Local time: 14:04
Member (2002)
German to Dutch
+ ...
SITE LOCALIZER
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
Giuliana Buscaglione  Identity Verified
United States
Local time: 05:04
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)
Michael Hesselnberg (X)  Identity Verified
Local time: 14:04
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
Özden Arıkan  Identity Verified
Germany
Local time: 14:04
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)
Amy Duncan (X)  Identity Verified
Brazil
Local time: 09:04
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
Özden Arıkan  Identity Verified
Germany
Local time: 14:04
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
Sol  Identity Verified
United States
Local time: 08:04
Spanish to English
+ ...
use Trados' Analyze Jul 18, 2004

It counts words (and repetitions)in many different file formats.
 
sbirkelu
sbirkelu
Local time: 14:04
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
NancyLynn
Canada
Local time: 08:04
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 & mon... See more
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 ▲ Collapse
 


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

Moderator(s) of this forum
Margarita[Call to this topic]
Jorge Rodrigues[Call to this topic]
James Heppe-Smith[Call to this topic]

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

word count in Excel : is it possible, electronically?







Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

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 »