In Excel, the Substitute function replaces a set of characters with another.
The syntax for the Substitute function is:
e.g.
In a word "Rajeev ", we want to replace "ee" with "i" then formula will be :
=SUBSTITUTE(A1,"ee","i")
nth appearance is optional. It is the nth appearance of old_text that you wish to replace. If this parameter is omitted, then every occurrence of old_text will be replaced with new_text.
The syntax for the Substitute function is:
= Substitute( text, oldtext, newtext, nthappearance )
e.g.
In a word "Rajeev ", we want to replace "ee" with "i" then formula will be :
=SUBSTITUTE(A1,"ee","i")
nth appearance is optional. It is the nth appearance of old_text that you wish to replace. If this parameter is omitted, then every occurrence of old_text will be replaced with new_text.
No comments:
Post a Comment