How to count characters in an Excel file with many pages (tabs)? Auteur du fil: angibi
|
|---|
angibi 
Italie
Local time: 17:54
anglais vers italien
+ ...
Can anyone tell me how to count characters in an Excel fil with many pages (tabs)??
Thank you!!
| | | |
gianfranco
Brésil
Local time: 12:54
Membre (2001)
anglais vers italien
+ ...
| 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
| | | |
RWSTranslati (X)
Allemagne
Local time: 17:54
allemand vers anglais
+ ...
Hello,
open the file in TagEditor and analyse the ttx file with Trados Workbench
Hans
| | | |
angibi
Italie
Local time: 17:54
anglais vers italien
+ ...
AUTEUR DU FIL | 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
Brésil
Local time: 12:54
Membre (2001)
anglais vers italien
+ ...
| 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
| | | |
Evert DELOOF-SYS
Belgique
Local time: 17:54
Membre
anglais vers néerlandais
+ ...
| 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: 16:54
anglais vers portugais
+ ...
| Total Assistant | Feb 3, 2004 |
You can try this one too!
| | | |
Gerard de Noord
France
Local time: 17:54
Membre (2003)
anglais vers néerlandais
+ ...
[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
Italie
Local time: 17:54
anglais vers italien
+ ...
AUTEUR DU FIL
OK, thanks to you all: I will try some of the suggestions!!
| | | |
Login to reply/comment 
