Pages sur ce sujet:   < [1 2]
Word count in Microsoft Excel?
Auteur du fil: transparx

Tjasa Kuerpick  Identity Verified
Slovénie
Local time: 18:47
Membre (2006)
slovène vers allemand
+ ...
SIMPLE SOLUTION Dec 27, 2012

Wörter zählen (wenn die Excel Funktionsbefehle in Deutsch sind):
=LÄNGE(A1)-LÄNGE(WECHSELN(A1;" ";""))+1

count words (if the Excel function commands are in English):
=LEN(A1)-LEN(SUBSTITUTE(A1;" ";""))+1

Note: You have to put the formula in the cell A2.
If you want to count the words in another cell, e.g. B19 insert B19 in the formula.
To count down the whole colum, click on the cell with the formula and pull down the cell.
That’s it!

[Edited at 2012-12-27 09:08 GMT]


Direct link Reply with quote
 

Javier Tomás  Identity Verified
Espagne
Local time: 18:47
Membre (2013)
anglais vers espagnol
+ ...
A dead-straight way to count words in Excel Apr 15, 2013

István Hirsch wrote:

If the text is trimmed (only one space between the words), press Ctrl + H (Replace), „replace” space with space, click Replace All and read the number of changes, add one.



This seems to me to be by far the simplest, most elegant way of counting words in Excel, without any copy-pasting, scripting or program-installing. There is one change to be made, though (step 3 below). The process would go on as follows:

1. Select the relevant cells.
2. Replace space by space and notice how many replacements have been made.
3. Add to that number the number of cells involved...

et voilà!


Direct link Reply with quote
 
AO0OGA
États-Unis
Thanks! Lifesaver Sep 7, 2013

Andrew Kozlovsky wrote:

Orchtech wrote:

to count the words of a text in an Excel cell use this equation.

=IF(LEN(TRIM(D2))=0,0,LEN(TRIM(D2))-LEN(SUBSTITUTE(D2," ",""))+1)

where D2 is the Cell where the text exists


Kind Regards,
Omar Shafik

[Edited at 2008-05-26 12:42]


Thanks!


Omar,

Thank you this worked perfectly.


Direct link Reply with quote
 

Ricardo Robina  Identity Verified
Mexique
Local time: 11:47
anglais vers espagnol
+ ...
Nifty prog Oct 23, 2013

John Jory wrote:

The problem with the wordcount in Word (and the macro provided above) is that numbers as well as characters such as '=' are counted as words.

FineCount is free, and works fine. Especially useful is that it also grabs the words in textboxes in MS Word (which are ignored by the embedded MS Word function).
It also distinguishes between 'Words only' and 'Words + numbers'.

Here's the link: http://www.tilti.com/tilti-com.software.finecount?pc_code=&ver=

Enjoy,

[Edited at 2009-05-27 15:24 GMT]


Nifty prog! Works for lots of formats. I like how it creates invoices and reports as well.


Direct link Reply with quote
 
AnnaEbner  Identity Verified
États-Unis
Local time: 11:47
Membre (2014)
espagnol vers anglais
Thank you so much!!! May 16, 2014

Ryan,

Thank you so much for the information. I know this post is outdated, but I have a HUGE excel document I am translating with several (dozens) spreadsheets, and the Count Anything program is quick and easy to install, and very easy to use. It's as easy as drag-and-drop!!!

Thanks again,

Anna E.


Direct link Reply with quote
 

Balasubramaniam L.  Identity Verified
Inde
Local time: 22:17
Membre (2006)
anglais vers hindi
+ ...
Using Trados Jun 13, 2015

Load the excel file into a Trados project and prepare it for translation. The word count will be displayed in the statistics available in the Reports tab, which will also give fuzzy details of the text.

Direct link Reply with quote
 
Charlie Delta
Norvège
An easier way of word count in Excel Jul 14, 2015

GKT wrote:

ninogulli wrote:

Hi,
Does Microsoft Excel have a word-count function? If it does, I don't seem to be able to find it.
Any help would be greatly appreciated!


I am not aware of any word-count function in Excel.

However, here is a trick you might want to try when you have to count words (or characters) in an Excel file:

1) Open the file
2) Save it in unicode text format (*.txt).
3) Open it with Word
4) Use the word-count function of word. Et voila!

I hope this helps

GKT


Or you can just copy and paste the text from Excel to Word, one or more columns or rows.


Direct link Reply with quote
 

VeroHouston
États-Unis
Local time: 11:47
espagnol vers anglais
+ ...
Excel Word Count for Mac May 18

I know this is an old thread but still relevant. I always copy and paste to Word and do a word count, but this file has 37 tabs!!! When I copied and pasted into Word, it was chaos and it shows many more words than what I think... So, in order to be fair to my client, I wanted to use something else, but cannot come up with any of these options above because they do not work for Mac. Anyone out there discover anything new? Thanks.

Direct link Reply with quote
 
Pages sur ce sujet:   < [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 »

Word count in Microsoft Excel?

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »



All of ProZ.com
  • All of ProZ.com
  • Recherche par terme
  • Travaux