3. Try
This: Edit
the Function Arguments Edit the
Text:B2.
You should see a preview of the data in all
capital letters, "PIGS".
Click OK.
Try This, Too: AutoFill the Formula
Use the AutoFill handle to fill down this formula in Column
G.
Memo to Self: The LOWER text function converts the text to all
lowercase letters.
The PROPER Text function begins each word with a
capital letter.
Formulas -> Function Library-> Text ->UPPER
Exam 77-888: Microsoft Excel Expert 2010 2. Applying Formulas and Functions 2.4. Apply functions in formulas: TEXT Functions UPPER |
|
| |
