SUBSTITUTE function

SUBSTITUTE(text,find,replace[,index]) substitutes replace for find in the given text string.

The optional argument index specifies which occurrence of find should be replaced. If it is omitted, or it is 0, then every occurrence of find is replaced with replace.