Pagina's in het onderwerp: [1 2] > | Counting words in an Excel file De persoon die dit onderwerp heeft geplaatst: Sandra Petch
|
Hi! Is it possible to count the number of words in an Excel doc in the same way they can be counted in a Word doc. I can't see any similar "stats" function. Or is cut and paste into Word the only option? I'd appreciate any pointers. Thanks in advance. | | | Jerzy Czopik Duitsland Local time: 17:37 Lid 2003 Pools naar Duits + ... Excel does not provide the same statistik funkction as Word does | Feb 3, 2006 |
since Excel is not designed to handle text. It is a "calculation sheet", not a "word processor". To count words in Excel you can either copy and paste into Word (bear in mind, that Word does not count exactly and you may encounter big trouble, as this program tends to count the same file very differently on different computers and the differencies may be quite high) or use a text counter, such as Practicount or Anycount, or you can analyse it with Trados. Regards J... See more since Excel is not designed to handle text. It is a "calculation sheet", not a "word processor". To count words in Excel you can either copy and paste into Word (bear in mind, that Word does not count exactly and you may encounter big trouble, as this program tends to count the same file very differently on different computers and the differencies may be quite high) or use a text counter, such as Practicount or Anycount, or you can analyse it with Trados. Regards Jerzy ▲ Collapse | | | Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER
Seems like copy and paste is my only solution. The client has used Excel to create a timeline, each event occupying a cell. I'm thinking a Word table would have done the job as well! Thanks again. Sandra | | | Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER ps word counting software | Feb 3, 2006 |
Which of Practicount or Anycount would you recommend? | |
|
|
One more option | Feb 3, 2006 |
You can "Save as" Text (tab delimited) (and then perhaps delete all tabs in the resutling txt file, if you do not feel like robbing your customer). Disadvantage: you have to export each sheet in your workbook extra. For exacting customers who are careful about their money (nearly all are), this txt export, or a commercial counting soltuion like Practicount, is better since it enables you to be objective. And you should agree with your customer on whether numerals are counted, etc.... See more You can "Save as" Text (tab delimited) (and then perhaps delete all tabs in the resutling txt file, if you do not feel like robbing your customer). Disadvantage: you have to export each sheet in your workbook extra. For exacting customers who are careful about their money (nearly all are), this txt export, or a commercial counting soltuion like Practicount, is better since it enables you to be objective. And you should agree with your customer on whether numerals are counted, etc. Antonin ▲ Collapse | | | Jerzy Czopik Duitsland Local time: 17:37 Lid 2003 Pools naar Duits + ... I cannot recommend any | Feb 3, 2006 |
because I only use Anycount, so I have no comparison at all. And you are absolutely right: any text table can be made better using Word, as it is a word processor, as already said. According to Microsoft Knowledge Base (or possibly I found these hints somwhere else, but they come from Microsoft): - if you want to have a good looking table, containing text, use Word
- if you need a table with calculati
... See more because I only use Anycount, so I have no comparison at all. And you are absolutely right: any text table can be made better using Word, as it is a word processor, as already said. According to Microsoft Knowledge Base (or possibly I found these hints somwhere else, but they come from Microsoft): - if you want to have a good looking table, containing text, use Word
- if you need a table with calculation or variables, use Excel
Regards Jerzy PS This is not the exact wording or M$, but only what I remember from what I read. ▲ Collapse | | | Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER Good alternative | Feb 3, 2006 |
Antonín Otáhal wrote: You can "Save as" Text (tab delimited) (and then perhaps delete all tabs in the resutling txt file, if you do not feel like robbing your customer). Disadvantage: you have to export each sheet in your workbook extra. Antonin Thanks Antonin, I'll try this method too. | | | Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER Practicount trial | Feb 3, 2006 |
I found a website www.01net.com where I can download a 15-day trial of Practicount. I'll give it a try. Thanks for the hint! | |
|
|
Nicole Maina Italië Local time: 17:37 Duits naar Italiaans + ... anycount trial | Feb 3, 2006 |
I have downloaded anycount for free and tried it for 30 days, then I bought it, but I have never used any other software, so I do not have any terms of comparison. anyway have a look at: http://www.anycount.com/ hth! nicole | | | Not really, but | Feb 4, 2006 |
Sandra Petch wrote: Is it possible to count the number of words in an Excel doc ...? Not at one fell swoop. What is possible is to count the number of characters, though not in a complete file, just in one cell at a time. Depending on the layout and size of the document, this feature can also be useful. A simple example: if all of the text is in one cell (cell A1), you can enter the count formula =LENGTH(A1) in cell B1. That delivers the number of characters. If all the text is in one column, you can proceed down through the rows in this way. Then just add up all the numbers with the formula =SUM(B1:Bx) 'x' being the row number of the bottom entry. There are limitations though! Can prove unpracticable. (LENGTH / SUM are the magic words in the English version, LÄNGE / SUMME in German, don't know any others) | | | Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER
Nicole Maina wrote: I have downloaded anycount for free and tried it for 30 days, then I bought it, but I have never used any other software, so I do not have any terms of comparison. anyway have a look at: http://www.anycount.com/ hth! nicole Thanks a lot Nicole, I'll try both. Have a good week. | | | Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER Counting characters | Feb 6, 2006 |
Cilian O'Tuama wrote: Not at one fell swoop. What is possible is to count the number of characters, though not in a complete file, just in one cell at a time. Thanks Cilian, that's a handy trick to know. | |
|
|
Sandra Petch Local time: 17:37 Frans naar Engels + ... ONDERWERPSTARTER Thanks everyone | Feb 6, 2006 |
Well I did the wordcount for one file the hard way, copying and pasting column by column into a Word document then removing the numbers and dates manually... For the second file I used a trial copy of anycount which is incredibly user-friendly. I think I will be happy to invest 29 euros! Thanks to everyone for such valuable input! Best regards | | | Rolf Kern Zwitserland Local time: 17:37 Engels naar Duits + ... In memoriam Use TextCount | Feb 7, 2006 |
Sandra Petch wrote: Hi! Is it possible to count the number of words in an Excel doc in the same way they can be counted in a Word doc. I can't see any similar "stats" function. Or is cut and paste into Word the only option? I'd appreciate any pointers. Thanks in advance. I use TextCount and am very satisfied. Visit www.textcount.com Good luck! Rolf Kern | | | Pagina's in het onderwerp: [1 2] > | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Counting words in an Excel file CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
| Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |