The SUBSTITUTE function replaces a part of text with another text. It can either replace all occurrences of the text or a specific instance. Note: This function is case sensitive.
==SUBSTITUTE(Text, Text to be replaced, Text to insert, Instance num) "Instance num" this specifies which occurrence of old text should be replaced with the new text. If it is omitted, then every occurrence of the old text will be replaced.
Let us substitute a text with another text, using the SUBSTITUTE function, with the help of the below video.