All functions / Text

REPLACE

Replaces characters at a given position.

Syntax

=REPLACE(old_text, start_num, num_chars, new_text)

Arguments

• old_text: The original text.
• start_num: Position of the first character to replace.
• num_chars: How many characters to replace.
• new_text: The replacement.