How to count characters in an Excel file with many pages (tabs)? Thread poster: angibi
|
|---|
angibi 
Italy
Local time: 05:35
English to Italian
+ ...
Can anyone tell me how to count characters in an Excel fil with many pages (tabs)??
Thank you!!
| | | |
gianfranco
Brazil
Local time: 00:35
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... See more 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] ▲ Collapse
| | | |
Hello,
open the file in TagEditor and analyse the ttx file with Trados Workbench
Hans
| | | |
angibi
Italy
Local time: 05:35
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]
| | |
|
|
|
gianfranco
Brazil
Local time: 00:35
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]
| | | |
| 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
| | | |
| ...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 inf... See more 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 ▲ Collapse
| | | |
| 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.
| | |
|
|
|
Andreia Silva
Portugal
Local time: 04:35
English to Portuguese
+ ...
| Total Assistant | Feb 3, 2004 |
You can try this one too!
| | | |
Gerard de Noord
France
Local time: 05:35
Member (2003)
English to Dutch
+ ...
[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
| | | |
angibi
Italy
Local time: 05:35
English to Italian
+ ...
TOPIC STARTER
OK, thanks to you all: I will try some of the suggestions!!
| | | |
Login to reply/comment 
