REPLACE function

description:

This function returns the second argument if the condition is met, otherwise it returns the third argument.

 

syntax:

=REPLACE( old_textstart_numnum_charsnew_text )

 

required arguments:

old_text The text string to replace.
start_num Starting position.
num_chars The number of characters to replace.
new_text The text used to replace the specified portion of the old text.