Mobile menu

text count in excel-files
Thread poster: Peter Lehner

Peter Lehner  Identity Verified
Austria
Local time: 07:29
Italian to German
+ ...
May 16, 2002

How can I count the text in excel-files?Opening the xls-file in word oder copying it into a word-file does not really work: it counts every single cell as at least one sign!



Kind regards and thanks in advance!



Martina



PS: Sorry for my english, I\'m french-translator. ;o)


Direct link Reply with quote
 

Elena Miguel  Identity Verified
Spain
Local time: 07:29
English to Spanish
+ ...
you can try... May 16, 2002

... highlighting the text in Excel and then copying it into a Word file with CTRL + C and CTRL + V, it should not count each cell as a word (at least it has never happened to me).



Hope it helps!


Direct link Reply with quote
 

Giuliana Buscaglione  Identity Verified
Austria
Local time: 07:29
Member (2001)
German to Italian
+ ...
Yes, Only Words... May 16, 2002

Hi,



I highlight the whole text, copy and paste it into a MS Word file using \"Inhalte einfügen\" (paste content??? Sorry, my sys is in German, menu \"Edit\" - Bearbeiten): pure word count.

Actually, if I am not working with SDLX, I do this with the original text, save it as a *rft file, translate, count words and only then I copy and paste the translation into an *.xls file... I am lazy opening and closing cells drive me crazy and make me waste time when I want to change my translation.



Cheers,



Giuliana







[ This Message was edited by: on 2002-05-16 17:20 ]


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 07:29
English to German
+ ...
Bug in Office 97 May 16, 2002

Beware of a bug in Excel97 when using the \"copy&paste-in-Word\" method: Excel97 will truncate any cell with more tha 255 characters. It works with Excel2k, though.



For those using Trados 5/5.5, T-Window for Excel contains an \"Analyse\" function.


Direct link Reply with quote
 

Peter Lehner  Identity Verified
Austria
Local time: 07:29
Italian to German
+ ...
TOPIC STARTER
Thank you!!! May 17, 2002

Vielen Dank euch allen für die sehr interessanten Antworten!



Ich habe allerdings auch Kunden, die ganze Handbücher im Excel schreiben (mit etwa 20 Tabellenblättern pro Datei), da sie so von Kapitel zu Kapitel blättern können. Hierfür Angebote zu erstellen bzw. die Zeilen zu ermitteln ist ein Horror!



Liebe Grüße,



Martina





Direct link Reply with quote
 

jccantrell  Identity Verified
United States
Local time: 22:29
Member (2005)
German to English
+ ...
Save a a text file May 17, 2002

You could also save the file as a text file (tab delimited) and then use Word to count it.



Worked for me.


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 »

text count in excel-files

Advanced search






SDL MultiTerm 2015
Guarantee a unified, consistent and high-quality translation with terminology software.

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

More info »
TMreserve
Wake up in the Morning and see that you have sold TMs and made Money overnight



The TM Market Place for Translators
New: Our Instant TM Download
TM owners: Upload your TMs into the online database
Customers: Analyse your text & instantly download a text-specific TM
Well over 1.2 BILLION translation units

More info »



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