Sunday, November 24

Tag: excel substitue function

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