How to Do Bulk Find & Replace in Excel (Many Pairs at Once)
Ctrl+H handles one pair at a time, so renaming hundreds of codes means hundreds of dialogs. Put every find→replace pair in a mapping table and apply them all to a column in a single pass.
Last updated: August 2026
| Column value | After mapping | |
|---|---|---|
| US | → | United States (map: US→United States) |
| UK | → | United Kingdom (map: UK→United Kingdom) |
Why Ctrl+H and SUBSTITUTE don't scale
Excel's Ctrl+H Find and Replace does exactly one pair per run, so recategorising a column or renaming a code list turns into hundreds of round trips through the dialog. The formula route, nested SUBSTITUTE calls, tops out fast, becomes impossible to read, and needs a helper column you then paste back as values — all before you can even check the result.
The 1-click way — Tellsheet's Bulk Find & Replace
Keep your pairs in a two-column mapping table — find on the left, replace on the right — and run Bulk Find & Replace. Tellsheet applies every pair at once down the column, so you can rename 200 codes or recategorise a field in a single pass. Choose whole-cell or substring matching, make it case-optional, and the mapping is read locally so nothing leaves your PC. Pairs with Regex Find & Replace and Clean Company Names.
Frequently asked questions
How many pairs can I apply at once?
As many as your mapping table holds — rename 200 codes or recategorise a whole column in one pass, instead of running Ctrl+H per pair.
Whole cell or substring?
Both. Match whole cells for exact values, or substrings to swap text anywhere inside a cell. Case matching is optional.
Where does the mapping come from?
A two-column range in your workbook, read locally on your device — nothing is uploaded.
Why not nested SUBSTITUTE?
It tops out fast, is unreadable, and needs a helper column. A mapping table stays editable and applies every pair in place.
Related Excel guides
Replace hundreds of values in one pass
Bulk Find & Replace applies a whole mapping table to a column at once — whole-cell or substring, case-optional, read locally.
Get Tellsheet free See pricing