SUBSTITUTE
Definition: The SUBSTITUTE function in Excel is used to replace a part of a text string with a different text string. Syntax: ==SUBSTITUTE(text, old_text, new_text, [instance_num]). Situation: This...