REPLACE

Syntax

REPLACE(old_text, start_num, num_chars, new_text)

Parameters

• old_text: Required. Text in which you want to replace some characters
• start_num: Required. The position of the character in old_text that you want to replace
• num_chars: Required. The number of characters in old_text that you want to replace
• new_text: Required. The text that will replace characters in old_text

Example

=REPLACE("abcdefghij", 6, 5, "*")