SUBSTITUTE Function
It is used to replace existing text with new text in a text string
Syntax: SUBSTITUTE(text,old_text,new_text,[instance_num])
Example: =SUBSTITUTE("Jitesh","J","H")
Result: Hitesh
It is used to replace existing text with new text in a text string
Syntax: SUBSTITUTE(text,old_text,new_text,[instance_num])
Example: =SUBSTITUTE("Jitesh","J","H")
Result: Hitesh
No comments:
Post a Comment