The REPLACE function replaces part of a text string, based on the number of characters you specify, with a different text string.

REPLACE takes 4 required arguments and no optional arguments:

Syntax: REPLACE(old_text, start_num, num_chars, new_text)

#1)
Using the REPLACE function:
#2)
The arguments for the REPLACE function are:
Argument Required? Description
old_text Required Text in which you want to replace some characters.
start_num Required The position of the character in old_text that you want to replace with new_text.
num_chars Required The number of characters in old_text that you want REPLACE to replace with new_text.
new_text Required The text that will replace characters in old_text.

Summary

The REPLACE function replaces part of a text string, based on the number of characters you specify, with a different text string.
comments powered by Disqus