Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

 

 

 

 

More Text Functions

3. Edit the Function Arguments

Select the Text in cell B2. You will see a preview of the data in all capital letters, UPPER. Click OK.

 

Use the AutoFill handle to paste this formula into the rest of the cells in the G Column.

 

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 -> Text ->UPPER

  

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3.7. Format or modify text using formulas

  3.7.1. Format text by using formulas: UPPER/LOWER