• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

SUBSTITUTE

The SUBSTITUTE function replaces old text within a text string with new text.

=SUBSTITUTE(text,old_text,new_text,instance_num)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint