REPLACE

The REPLACE replaces part of a text value, based on the number of characters specified, with a new text value.

Use

REPLACE( old_text, start_num, num_chars, new_text )
Replaces matching parts of text with a replacement text value.

Parameter	Required	Description
old_text	Yes	text in which to replace some characters
start_num	Yes	the position of the character in old_text to replace with new_text
num_chars	Yes	the number of characters in old_text to replace with new_text
new_text	Yes	the text that will replace characters in old_text

Returns

Text

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.