replace() Function

Replaces a piece of the specified text with new text.

Syntax

replace( old_text, start_num, num_chars, new_text )

old_text: (Text) The original text before replacement.

start_num: (Number) The positional index of the first character of the substring to be replaced.

num_chars: (Number) The length in characters of the substring to be replaced.

new_text: (Text) The text that will be inserted into the old text in place of the extricated substring.

Returns

Text

Notes

The first character of the entire text value is considered to have an index = 1.

Examples

You can experiment with this function in the test box below.

Test Input

replace("oldtext",1,3,"new") returns newtext

FEEDBACK