Find and Replace in Text Strings

The SUBSTITUTE() function will find and replace text. There is also a REPLACE() function, but it requires you to know the position of the characters you want replace, so it is a bit less useful.