Formulas -> Function Library-> Text ->UPPER

TEXT Functions: UPPER

Look at the text in any spreadsheet. The data entry may not be consistent. Some people never use capital letters, and some folks make every word begin with a capital letter. You can create a formula that formats the Text: UPPER, LOWER, PROPER.

 

1. Try It: Add a Label

Go to the Text Function spreadsheet.

Select Cell G1.

Type the label: UPPER

 

2. Try It: Use the UPPER Text Function

Select Cell G2.

Go to Formulas->Function Library-> Text.

Click on UPPER.

 

Keep going, please.

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: TEXT Functions UPPER