Word count on excel sheet
Thread poster: Magellan Kamelan

Magellan Kamelan  Identity Verified
Local time: 02:12
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


Direct link Reply with quote
 

Noura Tawil  Identity Verified
Syria
Local time: 03:12
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 fix
Noura

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


Direct link Reply with quote
 

neilmac  Identity Verified
Spain
Local time: 02:12
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]


Direct link Reply with quote
 

neilmac  Identity Verified
Spain
Local time: 02:12
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 fix
Noura

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


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


Direct link Reply with quote
 

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

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

Bye!


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

Advanced search






LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

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