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

Formulas -> Text ->UPPER UPPER Text 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 modifies the Text: UPPER, LOWER, PROPER.   Try It: UPPER Text 1. Add a Label Go to the Text Function spreadsheet. Select cell G1. Type the label: UPPER   2. Add a Function Select cell G2. Go to Formulas->Text -> UPPER.