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.
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.