The function replace is used to replace part of a text string with a different text string.
This is a more refine way than the replace tool built in excel.
Syntax:
=replace(text string, start character, number of characters, new text string)
Text string. This is the old text string or reference to a cell that contain the old text to be replaced.
Start character. is the position in the old text string to be replace with a new text string.
Number of characters. is the number of characters in the old text string that need to be replaced.
New text string. Is the new text string that will replace characters in the old text string.