Document Editing Problems

Bulk Find and Replace Word Text Using a Two-Column Mapping Table

Olivia MillerOlivia Miller Nov 14, 2026 870 views

Question details

Replace many codes in large Word documents using a two-column list of existing and replacement values.

Bulk Find and Replace Word Text Using a Two-Column Mapping Table
Product
Microsoft Word
Device & OS
not provided
Scenario
The user has a lookup table of codes and wants to apply the mappings without running Find and Replace separately for each pair.
Observed behavior
The desired result is a document in which the listed codes have been replaced according to their corresponding mapping values.
Before you start

Check that each code has the intended replacement and review whether any replacement value also appears in the find column. Consult the chosen macro's instructions for its required list format and test the mappings on a small sample document first.

Solution 1Recommended

Use the FRedit macro for mapped replacements in Word

Use FRedit from Paul Beverley's Computer Tools for Editors and Proofreaders collection to run a list of find-and-replace operations.

FRedit was identified as the best fit for this task. MultiSwitch and Quick Word Switch from the same collection are other options to consider.

Macro availability and installation depend on your Word version and security settings. Only enable macros from a source you trust.

1
Get the macro and instructions

Find Paul Beverley's Computer Tools for Editors and Proofreaders collection, then download FRedit and read its documentation or demonstration.

2
Prepare the replacement list

Use the FRedit instructions to convert the two-column mapping table into the list format the macro expects, with each original code paired with its replacement.

3
Install the macro

Follow the collection's instructions to add FRedit to Word. If Word blocks the macro, review the security prompt and enable it only if you trust the downloaded source.

4
Run a sample

Open a small sample document in Word, choose Developer > Macros, select FRedit, and run it using the prepared replacement list as directed by its instructions.

5
Check and process the document

Review the sample replacements, including any overlapping codes. Once the results are correct, open the full document and run FRedit with the same verified list.

Check replacement order: If a replacement produces text that appears later in the find list, a subsequent operation may change it again. Test the order with representative codes before processing the full document.
Free Microsoft Office alternative

Edit Word Documents with WPS Writer

WPS Writer is a free, lightweight Office alternative with a familiar interface for opening and editing Word documents. Its format compatibility makes it easy to move existing files into WPS, although it does not run the FRedit Word workflow for you.

Find and replace text in documents through a familiar editing interfaceOpen and edit Microsoft Word DOC and DOCX filesMove existing Word documents into a lightweight Office suiteUse free document-editing tools for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

Can Word use a two-column table as a bulk replacement list?

A macro such as FRedit can run a list of find-and-replace operations. Check the FRedit documentation for its required list format and convert your table accordingly.

Which macro is best for replacing many codes?

FRedit was the preferred option in this case. Paul Beverley's collection also includes MultiSwitch and Quick Word Switch, which are relevant alternatives for mapped replacements.

Where do I run an installed macro in Word?

Open the document and choose Developer > Macros, select the installed macro, and choose Run. Follow the macro's instructions for supplying the replacement list.

Why should I test the replacement list first?

Overlapping codes or replacement values that also appear in the find list can produce unintended changes. Run the list on a small sample and review the results before applying it to the full document.

Can WPS Writer run the FRedit Word workflow?

WPS Writer can open and edit Word DOC and DOCX files and supports ordinary Find and Replace, but it should not be assumed to run the FRedit Word macro workflow.