Excel Formula and Functions: SUBSTITUTE
A collection of MS Excel VBA and VSTO macros, functions, formulas, downloads and tutorials. ... ABOUT: SUBSTITUTE function substitutes(replaces) old_text with new_text. When you want to replace a certain text in a text string. SUBSTITUTE is different from...