Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
TEXT Functions UPPER
Formulas -> Function Library-> Text ->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... |
|
| |
