Text

Excel SUBSTITUTE function is a string function which used to replace a particular word - sentence from a cell. For example :- Excel help is a best website and if you want to replace best with great you will use substitute function in excel. Example given below in image. IMPLEMENT : SUBSTITUTE Function is used when you want to replace any word in an existing sentence or words. First select the cell of existing text then enter the old word that need to change, then enter new word that need to replace and last (instance_num) is optional. Hit enter and its done.