Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.4 Format and Modify Text with Functions: SUBSTITUTE

Formulas -> Function Library-> Text ->SUBSTITUTE Text Functions: SUBSTITUTE The Substitute Text function can find and edit specific words or phrases.   For example, you can compare the formula in Column F and Substitute "New Product Sales" for "Daily Sales."   1. Try This: Add a Label Go to the Text Functions sheet. Select Cell H1. Type the following label: Substitute   2. Try This, Too: Substitute the Text Select Cell H2. Go to Formulas->Function Library-> Text. Click on: SUBSTITUTE.   Keep going...