REPLACE

REPLACE — string old with num characters starting at start replaced by new

REPLACE(old,start,num,new)

old: original text

start: starting position

num: number of characters to be replaced

new: replacement string

This function is Excel compatible.

Synopsis