REPLACE

The REPLACE function replaces part of a text string with another text value based on the specified position and length. The index starts at 1, where the first character in the text string has an index of 1.

Syntax

REPLACE(old_string, index, length, replace_text)

Arguments

• old_string: The original text string.
• index: The starting position of the characters to replace.
• length: The number of characters to replace.
• replace_text: The text string that replaces the specified characters.

Return value

Returns the updated text string after replacement.

Example

REPLACE("Sales_US", 7, 2, "UK")

Returns Sales_UK.

Excel equivalent

REPLACE