Excel Formula Tips EXCEL FUNCTION – SUBSTITUTE ByPradeep Kumar SUBSTITUTE function is used to substitute the existing old text to new text.