SUBSTITUTE Function in Excel: Syntax, Examples and Free Practice
SUBSTITUTE is an Excel Text function. Replaces specific text within a string.
SUBSTITUTE syntax
Arguments
text: The text to work withold_text: The original text to search withinnew_text: The replacement textinstance_num: Which occurrence of the text to replace (optional)
When to use SUBSTITUTE
SUBSTITUTE is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice SUBSTITUTE online, free
Open the live Excel-style spreadsheet and try SUBSTITUTE yourself. No Excel install or sign-up needed to start.
Practice SUBSTITUTE now →Learn more
Read the tutorial: How to use SUBSTITUTE.
More Text functions
Frequently asked questions
What does the SUBSTITUTE function do in Excel?
Replaces specific text within a string.
What is the syntax of SUBSTITUTE in Excel?
The syntax is =SUBSTITUTE(text, old_text, new_text, [instance_num]). text: The text to work with; old_text: The original text to search within; new_text: The replacement text; instance_num: Which occurrence of the text to replace (optional).
Where can I practice SUBSTITUTE online for free?
Open the free live spreadsheet on Cellgrids and try SUBSTITUTE 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