Rebranding a product line. Standardizing vendor names. Swapping every old term in a copy deck for the new one. These are all the same job: many find and replace pairs, run against one column, in one pass.
Sheets can do it. It just makes you write every pair by hand, in order, inside a single expression.
The Old Way (Nested SUBSTITUTE)
SUBSTITUTE handles one pair. For a second pair, you wrap the first call. For a third, you wrap again.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, "Acme Corp", "Acme"), "acme corp", "Acme"), "ACME CORP", "Acme")That is three swaps of one term. A real list has twenty terms, so people reach for a lookup table and a helper column instead.
=IFERROR(VLOOKUP(A2, $D$2:$E$21, 2, FALSE), A2)That version only works when the cell is exactly the search term. It cannot replace a term sitting inside a longer sentence, and it misses anything with different casing or a trailing period. So you go back to nesting, and the formula gets longer every time someone adds a term.
The FITS Way (Just Ask)
With FITS, you list the replacements once in plain English and let the formula apply all of them.
=FITS("Replace Acme Corp with Acme, Globex Inc with Globex, and Initech LLC with Initech. Return the full text: " & A2)Every pair runs in one pass. Casing variants are handled without a separate nested call for each one. The rest of the sentence comes back untouched.
If your replacement list already lives in the sheet, point the formula at it instead of typing the pairs.
=FITS("Apply these find and replace pairs to the text. Pairs: " & JOIN(", ", D2:D21) & " Text: " & A2)Adding a twenty-first term now means adding a row, not rewriting the formula.
When to Use Each
For one exact swap on clean data, SUBSTITUTE is free and instant. Reach for =FITS() when the list of pairs is long, when casing and punctuation vary, or when the terms sit inside longer text. Related jobs use the same pattern: replacing one term case-insensitively, removing a word from an entire column, and trimming the spaces a bulk edit leaves behind. The full tour is in automating Google Sheets tasks you used to need regex for.
Stop Nesting SUBSTITUTE
FITS puts plain-English AI formulas inside Google Sheets. Describe every replacement once. Run them all in one pass. Free tier included.