REPLACE (Primitive Spread Function) replaces part of a text string with a different text string.

SYNTAX:

REPLACE(Old_text, Start_char, Num_chars, New_text)

REMARKS:

Arguments are as follows:

Argument Description 
Old_text Original text in which you want to replace characters. 
Start_char Starting position in the original text to begin the replacement. 
Num_chars Number of characters in the original text that you want to replace with characters from the new text. 
New_text New text that will replace characters in the original text. 

Use the REPLACE function to replace a specified number of characters in a specified location with other characters. Use the SUBSTITUTE function to replace specific text with other text. 

EXAMPLES:

The following formula replaces three characters with one character, starting with the sixth character in the provided text:

REPLACE("abcdefghijk", 6, 3, "%") equals abcde%ijk