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: