Word count on excel sheet
Thread poster: Magellan Kamelan

Magellan Kamelan  Identity Verified
Local time: 15:30
English
+ ...
Apr 11, 2013

Hello,

Can anyone tell me how to count words on an excel sheet ? Is there any standard words count tool.

Thanks

Magellan


 

Noura Tawil  Identity Verified
Syria
Local time: 17:30
Member (2013)
English to Arabic
+ ...
Old fashioned way Apr 11, 2013

Hi,
I just copy the whole text by pressing (Ctrl+A) to select everything, then (Ctrl+C) to copy, open a Ms Word file, paste everything (Ctrl+V) , look at the bar at the bottom of your word page, and there you can see the total word count (Or from the word file's properties).
There could be other more sophisticated ways, but.. well , that's a quick fixicon_smile.gif
Noura

[Edited at 2013-04-11 09:18 GMT]


 

neilmac  Identity Verified
Spain
Local time: 16:30
Spanish to English
+ ...
Counts vary Apr 11, 2013

To my knowledge, there is no "standard" method or application to perform an accurate wordcount on EL files. I have tried several programs or methods, and find that the best way for me is to convert the XL file into PDF then Word or txt and use the MS Word counter.

Propietary programs that I've tried out include Omnipage, Anycount ... and a few others I can't remember right now... and they all give varying word counts for XL (one of them even gave me different results on different PCs for the same file!).

I usually try to get clients to accept an hourly rate for any formats except Word, as they invariably cause delays and other processing problems that I don't consider part of the translation process per se.


PS: You can try out Anycount free for 30 days here: http://www.anycount.com/

[Edited at 2013-04-11 09:30 GMT]


 

neilmac  Identity Verified
Spain
Local time: 16:30
Spanish to English
+ ...
Agree Apr 11, 2013

Noura Tawil wrote:

Hi,
I just copy the whole text by pressing (Ctrl+A) to select everything, then (Ctrl+C) to copy, open a Ms Word file, paste everything (Ctrl+V) , look at the bar at the bottom of your word page, and there you can see the total word count (Or from the word file's properties).
There could be other more sophisticated ways, but.. well , that's a quick fixicon_smile.gif
Noura

[Edited at 2013-04-11 09:18 GMT]


Yes, and it saves messing about and wasting time trying out different softwares.


 

Luisa Tono  Identity Verified
Italy
Local time: 16:30
Czech to Italian
+ ...
count Apr 11, 2013

I always count exactly as Noura does. It is fast and simply.

Bye!


 


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 on excel sheet

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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