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.
Read This Article on How-To Geek ›
Source : How to Use the SUBSTITUTE Function in Microsoft Excel
