Need a word-count macro for excel

[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

 

[Dave O]

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.

 

[Dave Peterson]

Chip Pearson has one:
http://cpearson.com/excel/WordCount.htm

But it will depend on how you define word.

 

[Jack Crane]

But it will depend on how you define word.

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

 

[Dave Peterson]

Then he may be happy with that code.

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