Bulk Find and Replace Word Text Using a Two-Column Mapping Table
Question details
Replace many codes in large Word documents using a two-column list of existing and replacement values.

- 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.
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.
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.
Find Paul Beverley's Computer Tools for Editors and Proofreaders collection, then download FRedit and read its documentation or demonstration.
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.
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.
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.
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.
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.

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.




