SUBSTITUTE(text,old,new,num)
text: original text
old: string to be replaced
new: replacement string
num: if num is specified and a number only the numth occurrence of old is replaced
This function is Excel compatible.
REPLACE, TRIM.