Substitute Function

              Excel SUBSTITUTE Function           

Substitute function used to replace text from a string based on its occurrence. For example if we want to replace second Radha with She in below given line. This function will do this task.

Radha is a singer. Radha sings very well.

Syntax

               =SUBSTITUTE(text,old_text,new_text,[instance_num])