Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.4 Format and Modify Text with Functions: SUBSTITUTE     SUBSTITUTE Arguments 3. Try This: Enter the Arguments Text: F2   Old_text: "Daily Sales" Microsoft Excel will compare the text in your cell, F2. and determine if your data matches this Old_text.   New_text: "New Product Sales for" This is the text that Microsoft Excel will substitute when it finds a word or phrase that matches.   You should see a preview of the data to the right of the Argument.   Click OK.   Try This, Too: AutoFill the Formula Use the AutoFill handle to fill down this formula in Column H.

Formulas -> Function Library-> Text ->SUBSTITUTE