Need a word-count macro for excel

  • Thread starter Thread starter Jack Crane
  • Start date Start date
J

Jack Crane

A friend needs to find the total of all the words in an excel document. Is
there a macro around somewhere that does this?

Thanks,

Jack Crane
 
As an alternative, is it feasible to copy the Excel document, paste it
into Notepad (to clear formatting etc), the copy it again and paste it
into Word? That would give a word count, but a number such as "30" is
considered a word, just FYI.
 
But it will depend on how you define word.
Click to expand...

My friend often uses the macro in Word to get a word count in a Word
document. So he would define a word as one countable as 1 by Word.

Jack
 
Then he may be happy with that code.

Jack said:
My friend often uses the macro in Word to get a word count in a Word
document. So he would define a word as one countable as 1 by Word.

Jack
Click to expand...
 
Back
Top