Document Editing Problems

How to Remove Mail Merge Field Markers from a Word Document

Nimra Malik Sep 30, 2026 868 views

Question details

The user needs to remove residual mail merge field markers (guillemets) from a Word document after performing a field replacement.

How to Remove Mail Merge Field Markers from a Word Document

Product: Word Document
Device & OS: not provided
Scenario: Finalizing a document after replacing Word mail merge fields using Excel VBA, which leaves the marker characters visible.
Observed behavior: The angled quotation marks (field markers) remain visible in the final document and must be removed before saving.

Before you start

Ensure that all necessary data has been correctly merged or replaced before deleting the field markers, as removing them will convert the remaining text into static content.

Solution 1Recommended

Use the Find and Replace Feature

Easily remove the angled quotation marks (guillemets) using the built-in Find and Replace tool.

When VBA or third-party scripts replace the text inside a merge field but fail to delete the surrounding boundary characters, those characters become static text. The easiest way to clean them up is by doing a blank replacement.

Open Find and Replace

Press Ctrl+H on your keyboard to open the Find and Replace dialog box.

Clear formatting

Click the 'More' button (if available) and select 'No Formatting' to ensure you are only searching for the characters and not specific fonts or styles.

Find and remove opening markers

In the 'Find what' box, type or paste the opening marker («). Leave the 'Replace with' box completely empty, then click 'Replace All'.

Find and remove closing markers

Replace the character in the 'Find what' box with the closing marker (»). Keep the 'Replace with' box empty and click 'Replace All' again before saving your document.

Typing Guillemets: If you cannot copy the markers from the document, you can type them using keyboard shortcuts: Hold Alt and type 0171 on the numeric keypad for «, and Alt + 0187 for ».

Solution 2

Automate Removal using VBA

Modify your VBA script to include a wdReplaceAll command specifically targeting the residual marker characters.

Manage Documents Efficiently

Remove Field Markers Easily in WPS Writer

WPS Writer offers powerful Find and Replace tools and robust Mail Merge capabilities, making it easy to manage your document fields, clear unwanted markers, and finalize your files perfectly.

1. Open Document: Launch WPS Writer and open the document containing the leftover field markers.
2. Access Find and Replace: Press Ctrl+H to instantly bring up the Find and Replace dialog.
3. Target the Markers: Paste the « or » symbol into the 'Find what' input field.
4. Replace with Empty Space: Make sure the 'Replace with' field is totally empty, then click 'Replace All'.

Fully compatible with Microsoft Word formats (.docx, .doc)Built-in robust Mail Merge functionalityAdvanced Find and Replace options for quick document cleanupLightweight, fast, and free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why are mail merge field markers still showing in my document?

When fields are unlinked or their contents are replaced via external scripts like VBA without properly deleting the field boundaries, the raw guillemet symbols (« and ») are left behind converted as regular static text.

Can I hide field codes instead of deleting them?

Yes, if they are still functioning as actual Word field codes, you can toggle their visibility by pressing Alt+F9. However, if they have been flattened into plain text characters by a script, they cannot be hidden and must be deleted.

How do I type the guillemet characters (« and ») on my keyboard?

You can copy them directly from your text, or use the Alt code method. Ensure Num Lock is on, hold the Alt key, and type 0171 on the numeric keypad for «, or 0187 for ».

Document & File Issues