How to count characters in an Excel file with many pages (tabs)?
Thread poster: angibi

angibi  Identity Verified
Italy
Local time: 17:54
English to Italian
+ ...
Feb 3, 2004

Can anyone tell me how to count characters in an Excel fil with many pages (tabs)??
Thank you!!


Direct link Reply with quote
 

gianfranco  Identity Verified
Brazil
Local time: 12:54
Member (2001)
English to Italian
+ ...
Copy the text in Word Feb 3, 2004

It should be quite simple. Just select and copy the whole content of each worksheet (tab) and paste them, one by one, into a Word document.

It will take the format of Word tables, but the formatting should not be relevant for your purposes.
Once the text is in Word, you can also delete any content that you don't need to count.

Now run the word count in MS Word (Tools > Word count), and it will display the two character counts too, one with spaces and one without.

Gianfranco



[Edited at 2004-02-03 16:28]


Direct link Reply with quote
 

RWSTranslation
Germany
Local time: 17:54
Member (2007)
German to English
+ ...
TTX Feb 3, 2004

Hello,

open the file in TagEditor and analyse the ttx file with Trados Workbench

Hans


Direct link Reply with quote
 

angibi  Identity Verified
Italy
Local time: 17:54
English to Italian
+ ...
TOPIC STARTER
isn't there any other quicker solution?? Feb 3, 2004

Gianfranco Manca wrote:

It should be quite simple. Just copy the whole content of each worksheet (tab) into a Word document.

It takes the format of Word tables, but the formatting should not be relevant for your purposes.
Once the text is in Word, you can also delete any content that you don't need.

Now run the word count in MS Word (Tools > Word count), and it will display the two character counts too, one with spaces and one without.

Gianfranco


[Edited at 2004-02-03 16:05]


Direct link Reply with quote
 

gianfranco  Identity Verified
Brazil
Local time: 12:54
Member (2001)
English to Italian
+ ...
It is a quick solution Feb 3, 2004

Unless you have a very large number of Excel files, each of them with a very large number of tabs.

In that case some operations may be automated writing a macro.
This solutions is also time consuming (if you write the macro yourself) or expensive (if you hire a VBA programmer) but, I wonder if this is really justified in your case?

How many files and tabs do you have?


GF

[Edited at 2004-02-03 17:05]


Direct link Reply with quote
 

Giovanni Guarnieri MITI, MIL  Identity Verified
United Kingdom
Local time: 16:54
Member (2004)
English to Italian
get a specific software, like Practicount Feb 3, 2004

you can download a demo version (sorry, I don't remember the URL now), which will expire after 30 days.

Giovanni


Direct link Reply with quote
 

SysfilterMaker
Germany
Local time: 17:54
...or you could use Sysfilter for Excel. Feb 3, 2004

This tool exports text into text format or other formats. Then you could count your files as usual.

Export options of Sysfilter for Excel:

Excel files can be exported into the following formats:

For free:
TXT ("tab separated - ANSI ")
HTML
UNICODE
DOC - (table format)

Only in demo mode:
Text export to RTF format /import to xls.

Further informations on my web site:
http://www.ecm-engineering.de/engl/prod_Software.htm

Un saludo desde Alemania
Wilhelm Polmann


Direct link Reply with quote
 

Evert DELOOF-SYS  Identity Verified
Belgium
Local time: 17:54
Member
English to Dutch
+ ...
Practicount at Practiline.com Feb 3, 2004

Giovanni Guarnieri, MITI wrote:

you can download a demo version (sorry, I don't remember the URL now), which will expire after 30 days.

Giovanni


Here it is:

www.practiline.com for Practicount & Invoice version 2.4
Very handy tool indeed.
15 days trial use.


Direct link Reply with quote
 

Andreia Silva  Identity Verified
Portugal
Local time: 16:54
English to Portuguese
+ ...
Total Assistant Feb 3, 2004

You can try this one too!

Direct link Reply with quote
 

Gerard de Noord  Identity Verified
France
Local time: 17:54
Member (2003)
German to Dutch
+ ...
Easy way Feb 3, 2004

[quote]Gianfranco Manca wrote:

It should be quite simple. Just select and copy the whole content of each worksheet (tab) and paste them, one by one, into a Word document.
[quote]
Or just open the XLS file with Microsoft Word.

Regards,
Gerard


Direct link Reply with quote
 

angibi  Identity Verified
Italy
Local time: 17:54
English to Italian
+ ...
TOPIC STARTER
thank you Feb 4, 2004

OK, thanks to you all: I will try some of the suggestions!!

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 »

How to count characters in an Excel file with many pages (tabs)?

Advanced search






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



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