How to Use the SUBSTITUTE Function in Microsoft Excel
To replace a string of text, numbers, or symbols, Microsoft Excel offers a function called SUBSTITUTE. This function replaces the specified string with your choice of string. We’ll show you how to use it in your spreadsheets.
Source: howtogeek.com