SUBSTITUTE(text, old, new [,num])
SUBSTITUTE replaces old with new in text. Substitutions are only applied to instance num of old in text, otherwise every one is changed.
SUBSTITUTE("testing","test","wait") equals "waiting".
REPLACE, TRIM.