How do you count words in a MS Excel file?

Question

It is very easy to count words in a MS Word file but I could not find a method to count words in a MS Excel file. I evolved a way by copying the text from excel file and pasting in the word file and then counting the words but it consumes a great deal of time.

Could you suggest me an easy and quick way to do so?

Thanks

Answer 1

Excel is not a word processor and as such does not have that kind of functionality.

Answer 2

In Excel, counting words goes on three types
1- You have word on each cell, then the counting goes on the number of cells with text using the function COUNTA
=COUNTA( A:A)-COUNT( A:A)
will count the cells that have an entry with text in column A.
2- You have a cell with more than word in one cell, in this case you can count the number of spaces in that cell +1
This is a good formula that I made to do this
=LEN( C7)-LEN( SUBSTITUTE( C7," ","" ))+1
3- You have a combined of the 1 and 2 options above.
In this case you will need to do more than this and the solution will need more info from you

mail me here in Y! Answers for that

Trust me, I am the VBAXLMan

Answer 3

i do not understand no matter if there is such software or no longer, yet there's a trick to do the element you want. First, replica the cellular content fabric & paste it in MS note. Or, pick all to replica the finished sheet. Then, run the note count number in approaches menu. you'll get many informations from note count number. which include, what percentage characters you've.

Answer 4

Not really. If you need to work with WORDS, then excel is not for you - there is no *concept* of a "word" in excel. There is such a thing as *specialized* software - that kind that is good at what it's meand to be doing. Using it in other ways is no guarantee that you'll get what you want.

Have you considered working in microsoft WORD instead of in excel? ;-)