Nested SUBSTITUTE (multiple replacements) Function in Excel: Syntax, Examples and Free Practice
Nested SUBSTITUTE (multiple replacements) is an Excel Text function. Chains multiple SUBSTITUTE calls together to make several different text replacements in one formula.
Nested SUBSTITUTE (multiple replacements) syntax
Arguments
text: Original textold1/new1: First replacement pairold2/new2: Second replacement pair
When to use Nested SUBSTITUTE (multiple replacements)
Cleaning both dashes and underscores out of a product code in a single formula.
Practice Nested SUBSTITUTE (multiple replacements) online, free
Open the live Excel-style spreadsheet and try Nested SUBSTITUTE (multiple replacements) yourself. No Excel install or sign-up needed to start.
Practice Nested SUBSTITUTE (multiple replacements) now →More Text functions
Frequently asked questions
What does the Nested SUBSTITUTE (multiple replacements) function do in Excel?
Chains multiple SUBSTITUTE calls together to make several different text replacements in one formula.
What is the syntax of Nested SUBSTITUTE (multiple replacements) in Excel?
The syntax is =SUBSTITUTE(SUBSTITUTE(text, "old1", "new1"), "old2", "new2"). text: Original text; old1/new1: First replacement pair; old2/new2: Second replacement pair.
Where can I practice Nested SUBSTITUTE (multiple replacements) online for free?
Open the free live spreadsheet on Cellgrids and try Nested SUBSTITUTE (multiple replacements) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts