REPLACE function


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



=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.