writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 49:
Line 49: − + − + + + + +
no edit summary
=SUBSTITUTE(A1,"TUTE", "TUTION",1) : Replaces first instance of old text with new text. <br />Returns '''SUBSTITUTION''' as output.
=SUBSTITUTE(A1,"TUTE", "TUTION",1) : Replaces first instance of old text with new text. <br />Returns '''SUBSTITUTION''' as output.
=SUBSTITUTE(A2,"123","888",2) :Replaces second instance of old text with new text. Returns '''abc123abc888''' as output.
=SUBSTITUTE(A2,"123","888",2) :Replaces second instance of old text with new text. <br />Returns '''abc123abc888''' as output.
=SUBSTITUTE(A2,"123","888") : Replaces all instances of old text with new text. Returns '''abc888abc888''' as output.
=SUBSTITUTE(A2,"123","888") : Replaces all instances of old text with new text. <br />Returns '''abc888abc888''' as output.
=SUBSTITUTE(A3,"Cost", "Selling") : Returns '''Selling Price''' as output.
=SUBSTITUTE(A3,"Cost", "Selling") : Returns '''Selling Price''' as output.
==Related Videos==
{{#ev:youtube|YvHrFS-sfiU|280|center|SUBSTITUTE}}
== See Also ==
== See Also ==