REPLACE Function in Excel: Syntax, Examples and Free Practice
REPLACE is an Excel Text function. Replaces part of a text string based on position, not content.
REPLACE syntax
Arguments
old_text: The original text to search withinstart_num: The character position to start fromnum_chars: How many characters to returnnew_text: The replacement text
When to use REPLACE
REPLACE is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice REPLACE online, free
Open the live Excel-style spreadsheet and try REPLACE yourself. No Excel install or sign-up needed to start.
Practice REPLACE now →Watch: REPLACE in Excel
More Text functions
Frequently asked questions
What does the REPLACE function do in Excel?
Replaces part of a text string based on position, not content.
What is the syntax of REPLACE in Excel?
The syntax is =REPLACE(old_text, start_num, num_chars, new_text). old_text: The original text to search within; start_num: The character position to start from; num_chars: How many characters to return; new_text: The replacement text.
Where can I practice REPLACE online for free?
Open the free live spreadsheet on Cellgrids and try REPLACE 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