REPLACE(old_text, start_num, num_chars, new_text)

The REPLACE function replaces characters within text. This enables you to replace a specified text string with another text string.

old_text contains the string which is to be replaced.

start_num gives the number of the character at which the replacement is to begin.

num_chars is the number of characters to be replaced.

new_text is the text that will replace the relevant string in old_text.

For example:

REPLACE("November", 1, 3, "Dec")  returns "December"

REPLACE("Mr Bill Clinton", 1, 7, "President") returns "President Clinton"

See also:

Other text functions