What is the use of REPLACE Function in Excel?

Data Science, AI and ML
,
#1

The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example =REPLACE(“XYZ123”,4,3,“456”) returns “XYZ456”.

  • Purpose: Replace text based on location
  • Return value: The altered text.

Syntax

=REPLACE (old_text, start_num, num_chars, new_text)

Arguments

  • old_text - The text to replace.
  • start_num - The starting location in the text to search.
  • num_chars - The number of characters to replace.
  • new_text - The text to replace old_text with.

Example:

To replace the “C” in the path below with a “D”:

=REPLACE("C:\docs",1,1,"D") // returns "D:\docs"