Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Counting Values in Table Cells.
Dan has a document with a huge table with many rows and six columns. In one of the columns he enters a single character (F, P, or B) for each row. Periodically Dan needs to count the total occurrences of the Fs, Ps, and Bs in that column. He wonders if there is some kind of macro that he can use to do the counting.
It is possible to do this with a macro, but the macro would not be simple. It is far easier to do a simple find and replace operation to get the desired totals. Follow these general steps:
Figure 1. The Replace tab of the Find and Replace dialog box.
The result is that the character is replaced with itself, and Word lets you know how many replacements were made. (If Word asks you if you want to make the replacements in the rest of the document, turn down the kind offer.) You can repeat the steps for each of the other characters in the column, and you will have your desired counts.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (528) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Counting Values in Table Cells.
Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!