Excel SUBSTITUTE Function
What is the Excel SUBSTITUTE Function? The excel SUBSTITUTE function replaces the old text to the new text by matching the same word. The SUBSTITUTE function works in case sensitive and has no support for a wildcard character. SUBSTITUTE Syntax SUBSTITUTE(text, old_text, new_text, ) text, required, …