It is very easy to count words in a MS Word file but there appears to be no such function in MS Excel. I have to copy the text from Excel and then paste it in Word to count words but it consumes a great deal of time.
Is there any simpler method to count words in Excel?
2007-01-26 05:50:03 · 2 answers · asked by paresh p 1 in Computers & Internet ➔ Software
You can use len() function. Divide this with a arbitrary number to get an estimated word count. Works fine except for bean counters who probably don't mind the extra step to get an exact answers.
2007-01-26 16:46:16 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
In Excel, counting words is going on 3 varieties a million- you've note on each and every cellular, then the counting is going on the type of cells with textual content utilizing the function COUNTA =COUNTA( A:A)-count number( A:A) will count number the cells which have an get entry to with textual content in column A. 2- you've a cellular with more advantageous than note in a unmarried cellular, subsequently you may count number the type of areas in that cellular +a million that is a sturdy formula that I made to attempt this =LEN( C7)-LEN( change( C7," ","" ))+a million 3- you've a blended of the a million and a pair of recommendations above. subsequently you'll want to do more advantageous than this and the answer will want extra information from you mail me right here in Y! solutions for which have self belief me, i'm the VBAXLMan
2016-12-03 02:06:46 · answer #2 · answered by Anonymous · 0⤊ 0⤋