The Excel Replace function is similar to the Excel Substitute Function. The difference between the two functions is:
The Excel Replace function replaces all or part of a text string with another string.
The syntax of the function is:
Where the function arguments are:
old_text    The original text string, that you want to replace a part of. 
start_num    The position, within old_text, of the first character that you want to replace. 
num_chars    The number of characters to replace. 
new_text    The replacement text. 
Note that the Excel Replace Function is not suitable for languages that use the doublebyte character set (e.g. Chinese, Japanese, Korean). These languages should use the ReplaceB function, which is explained on the Microsoft Office website.
Column B of the following spreadsheet shows two examples of the Excel Replace Function.
Formulas:
 Results:

For further information and examples of the Excel Replace function, see the Microsoft Office website.
If you get an error from the Excel Replace function, this is likely to be the #VALUE! error:
#VALUE!    Occurs if either:

The Excel Replace function is designed for use with text strings and returns a text string. Therefore, if you attempt to use the replace function with a date, time or a number, you may get unexpected results.
If you are not planning to use the date, time or number in further calculations, you could solve this problem by converting these values into text, using the Excel Text To Columns tool. To do this:
The Replace function should now work as expected on the values that have been converted to text.