REPLACE Function
It is used to replace a part of text string with new text.
Syntax: REPLACE(old_text,start_num,num_chars,new_text)
Example: =REPLACE("I love Banana",3,4,"hate")
Result: I hate Banana
It is used to replace a part of text string with new text.
Syntax: REPLACE(old_text,start_num,num_chars,new_text)
Example: =REPLACE("I love Banana",3,4,"hate")
Result: I hate Banana
No comments:
Post a Comment