J-Walk & Associates, Inc.

Word Frequency Generator Posted

I just posted a new tip (with a demo file) that some people might find useful: A Macro To Count Word Frequencies.

Paste some text into column A and run the macro. You'll have a frequency count of every word in the text. The download includes three sets of text:

• All of the Beatles song titles
• The first few paragraphs of Moby Dick
• A George W. Bush acceptance speech from 2000

- Reader Comments -

Following are comments in response to this item.
The most recent comment is at the bottom.

1. By Andy McKenzie. Comment posted 23 August, 2008 9:57am

   How many words will the macro work up to?
2. By John Walkenbach. Comment posted 23 August, 2008 10:23am

   The theoretical limit is the number of cells in a column. That's 1,04,8576 in Excel 2007, and 65,536 in previous versions. There's no error handling, so the macro will bomb when it fills up the column with words.
   
   I haven't tested these limits, however. That would be a good weekend project for you.