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.

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

But it will depend on how you define word.

Jack Crane wrote:

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 Peterson

Dave Peterson wrote in news:441855D7.6BB79482
@verizonXSPAM.net:

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

Then he may be happy with that code.

Jack Crane wrote:

Dave Peterson wrote in news:441855D7.6BB79482
@verizonXSPAM.net:

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