Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a word-count macro for excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a word-count macro for excel
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a word-count macro for excel
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a word-count macro for excel
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a word-count macro for excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy from Excel to word by macro with certain format | Excel Discussion (Misc queries) | |||
Word count | Excel Discussion (Misc queries) | |||
Linking table in Excel to word | Links and Linking in Excel | |||
2 questions: Using solver in Macro AND converting to Word document to print A3 | Excel Discussion (Misc queries) | |||
SPECIFIC WORD COUNT FROM A RANGE | Excel Discussion (Misc queries) |