Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, 2016, 2019, and Word in Office 365. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Counting Fields in a Document.

Counting Fields in a Document

by Allen Wyatt
(last updated December 14, 2018)

Barry has a fairly large Word document (about 50 pages) that contains hundreds of XE fields used to build an index. He wonders if there is a way to produce a count of how many XE fields exist in the document that doesn't involve counting them by hand.

There are a few ways that you can approach this need. The first is to rely on Word's Find and Replace capabilities. Here are the simple steps:

  1. Display the Word Options dialog box. (In Word 2007 click the Office button and then click Word Options. In Word 2010 or a later version, display the File tab of the ribbon and then click Options.)
  2. At the left side of the dialog box click Display. (See Figure 1.)
  3. Figure 1. The Display options of the Word Options dialog box.

  4. Make sure that hidden text is displayed in your document. (Just make sure that either the Hidden or all check boxes are chosen.)
  5. Click OK.
  6. Press Ctrl+H. Word displays the Replace tab of the Find and Replace dialog box. (See Figure 2.)
  7. Figure 2. The Replace tab of the Find and Replace dialog box.

  8. In the Find What box enter "^19 XE" (without the quote marks).
  9. In the Replace With box enter "^&" (again, without the quote marks).
  10. Click on Replace All.

Word finds all the XE fields and displays a count of how many replacements were made. This is your desired count. The code ^19 (in step 6) is the character code for the opening field brace that indicates only fields should be matched. You can, if desired, now turn off the display of Hidden text.

There are a couple of things to note about this sequence of steps. First, some folks may think that there is a step missing in the above: pressing Alt+F9 to display all the field codes in the document. Actually, this step isn't required because XE fields are always displayed, as long as hidden text is visible. In other words, pressing Alt+F9 doesn't affect their display one way or the other. If, however, you are counting a field other than the XE field, you'll want to display the field codes before doing the steps.

Another thing to note is that Word is rather lenient when it comes to the number of spaces that can follow an opening field brace. The steps above only finds XE fields in which a single space separates the opening field brace (^19) and the XE code. If your fields contain more spaces (or no spaces), then those instances of the field won't be counted. For this reason, you may want to simply search for XE (without the ^19 code and space) and turn on the Match Case check box. This will work as long as there are no other instances of capitalized XE characters within your document.

There are also some simple macros you can use to count the XE fields. If the only fields in your document are the XE fields, then the macro is very simple, indeed:

Sub CountFields()
    Dim iCnt As Integer

    iCnt = ActiveDocument.Fields.Count
    MsgBox "There are " & iCnt & " fields in the document."
End Sub

This approach won't work, however, if there are other fields in your document. Remember—fields are used to actually place your index in a document. So if you are using XE fields for index entries, you are probably using a field to insert the actual index itself. And, of course, there could be many other fields in your document for other purposes. In this likelihood, your macro needs to examine each field and determine if it is an XE field or not.

Sub CountXEFields()
    Dim iCnt As Integer
    Dim f As Field

    For Each f In ActiveDocument.Fields
        If f.Type = wdFieldIndexEntry Then iCnt = iCnt + 1
    Next
    MsgBox "There are " & iCnt & " XE fields in the document."
End Sub

This macro checks the Type property of each Field object to make sure it is an XE field. If so, it is added to the count and then the count is displayed at the end of the macro.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (11754) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Office 365. You can find a version of this tip for the older menu interface of Word here: Counting Fields in a Document.

Author Bio

Allen Wyatt

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. ...

MORE FROM ALLEN

Clean Up Your Macro List

Macros are part of the document and template that are loaded into memory when you open a file. If you have "junk" macros ...

Discover More

Displaying the File Tab of the Ribbon by Default

When you first start Word, it displays the Home tab of the ribbon. If you want to display a different ribbon tab by ...

Discover More

Determining if Overtype Mode is Active

Your macro may need to determine if the user has overtype mode turned on. You can find out the overtype status easily by ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (ribbon)

Inserting the Document Title in Your Document

One of the pieces of information you can store with a document is the title of that document. Using fields, you can then ...

Discover More

Inserting Summary Information

Want to insert into your document those snippets of information that you know Word maintains about your document? It's ...

Discover More

Calculating Dates with Fields

Can you calculate dates using fields? Yes, but you probably don't want to except as a learning experience. An easier way ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 7 + 4?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.