Thursday, November 21

Tag: Substitute in excel

Apr22020 by excelhelp13No Comments
SUBSTITUTE Space with Hypen

SUBSTITUTE Space with Hypen

FORMULAS, Text
SUBSTITUTE Function is used when you want to replace any word, symbol or any sign or hypens (-) 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
Read More
Mar162020 by excelhelp132 Comments
SUBSTITUTE Function In Excel

SUBSTITUTE Function In Excel

FORMULAS, 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.
Read More