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 formula is appropriate in situations where you need to replace a part of a text string with a different text string.

Example: If you have a text string in cell A1 that says “The quick brown fox jumps over the lazy dog”, and you want to replace “fox” with “cat”, you would use the formula =SUBSTITUTE(A1, “fox”, “cat”). This would return the text string “The quick brown cat jumps over the lazy dog”.