A nifty little proofreading and editing macro: ProperNounAlyse

If you proofread or copyedit fiction or non-fiction, or you're self-editing your own books, here's a macro that will highlight potential inconsistencies in proper-noun usage.

---

About this macro

ProperNounAlyse was created by my colleague Paul Beverley, and it’s just one of a huge number of macros available on his website: Word Macro Tools.

I've written this post for the person who doesn't use macros and is nervous about trying. I think it’s such a shame when a fear of tech leads to lost opportunities for those who want to increase productivity (which is great for the editorial pro) and improve quality (which is great for the client).

---

Why bother? Three reasons

Reason 1
ProperNounAlyse is easy to install, even for those with absolutely no technical savvy, and quick to run.

Reason 2
It’s great for picking up inconsistencies in proper nouns (even double words, e.g. Louise Harnby vs Louise Hornby) while allowing you to maintain complete control over the text.

This is because it’s not changing anything in the document you’re working on; rather, it works through the text in a Word document and provides a summary analysis of what it finds.

​That leaves you free to identify what needs sorting and what needs leaving well enough alone. I find it particularly useful when I'm proofreading fiction with lots of characters whose names may inadvertently end up being spelled slightly differently.

​A writer can become so immersed in the story they’re building that these kinds of slippages are easily missed. And even the best professional proofreader is only human, so using a little bit of simple tech to complement the eyes and brain makes good sense.

Reason 3
While you’ll find it useful for paid work, it’s also a sharp little tool for providing insight into the state of a file you’re being asked to quote for.

​One of my colleagues routinely runs this in conjunction with another couple of macros in order to get an overview of the author’s consistency. I've taken a leaf out of her book and started using ProperNounAlyse in this way too.

---

Installing ProperNounAlyse

After you've downloaded the macro from Paul's website, use Word’s navigation menu (or Ctrl F on a PC) to open the Find function. Type “Sub ProperNounAlyse” into the search field and hit Return. That will take you to the start of the relevant script.

Select and copy the script from “Sub ProperNounAlyse()” down to “End Sub”. Paul’s helped us out by highlighting the name of each new macro.

Still with Word open, open the “View” tab and click on the “Macros” icon on the ribbon.

This will open up a new window.

If you don’t have any macros already loaded:

• To get you going, create a test macro that you can delete later.
• First, make sure the Normal.dotm template is showing in the "Macros in:” box.
• Type TEST into the “Macro name:” box.
• Click on “Create”. Your TEST macro will now show up. From now on, it’ll be easy as pie to add additional macros.

If you have macros loaded (your TEST macro or any other):

• Click on “Edit”.

This will open up another window:

• If necessary, use the scroll bar to take you to the bottom of the text.
• Paste the ProperNounAlyse script at the end, under “End Sub”.
• Close the window using the X in the top right-hand corner.

​The installation is now complete.

---

Running ProperNounAlyse

• Open the Word file you want to analyse.
• Click the “View” tab.
• Click the “Macros” icon on the ribbon.
• Select "ProperNounAlyse" from the list.
• Click “Run”.

---

The macro in action

Below is a simple word list of proper nouns with lots of inconsistencies – differences in accent use, apostrophe use and spelling.

I run ProperNounAlyse on the document. It analyses the text and then creates a new Word file with the following results:

I’m provided with an at-a-glance summary of potential problems that I need to check. It may be that the differences identified are not mistakes, but I know what to look for.

---

“I don’t need to use techie tools … my eyes are good enough”

Macros don’t get tired. Macros don’t get distracted. I don’t believe any proofreader who claims they can do as good a job with their eyes alone as they can do with their eyes and some electronic assistance. It’s a case of using these kinds of tools as well as, not instead of, the eyes and brain.

I could have relied on my eyes to find all of the above problems, and in a small file I would hope to have hit the mark 100%. But if I’d been working on 100,000 words of text, and there were twenty key characters, a plethora of grammatical glitches, two major plot holes, numerous layout problems, and a mixture of hundreds of other inconsistencies regarding hyphenation, capitalization, punctuation and regional spelling variation, there would have been a lot of problems to solve; I want to utilize every tool available to help me do that.

Yes, my eyes and brain are two of those tools. But using macros like ProperNounAlyse and others (PerfectIt, for example, just because it’s another favourite!) speeds me up, pure and simple, and massively reduces the chance of a miss.

I ran ProperNounAlyse on a recent fiction proofread for an independent author who is a phenomenally good writer – great plot, excellent pacing, engaging characters. But he was so busy crafting the 95,000 words it took to build a fantastic story that he’d introduced a lot of proper-noun inconsistencies. That’s fine – it’s not his job to deal with these; it’s mine. It took me minutes, rather than hours, to locate them and deal with them. And I know I found them – every one of them.

---

What will the client remember?

If you’re still reluctant to try out ProperNounAlyse (or any other editorial tool for that matter), consider this: What will the client remember? The three hundred mistakes that you spotted or the three howlers you missed?

​When it comes to proper nouns, especially in large volumes of character-based editorial work, it’s too easy to miss a discrepancy. And character names stand out to readers. Taking just a few minutes to run a simple-to-use macro might determine whether your client thinks your work was pretty good or outstanding.

Which of those is likely to gain you a repeat booking or a referral to another potential client?

---

About Louise Harnby

Louise Harnby is a line editor, copyeditor and proofreader who specializes in working with crime, mystery, suspense and thriller writers.
​
She is an Advanced Professional Member of the Chartered Institute of Editing and Proofreading (CIEP) and co-hosts The Editing Podcast.

• Get in touch: Louise Harnby | Crime Fiction & Thriller Editor
• Connect: X @LouiseHarnby, Facebook and LinkedIn
• Learn: Books and courses
• Discover: Resources for authors and editors

---