UPPER and LOWER
Part of the Fundamentals section of Coddy's Excel journey. Lesson 30 of 42.
Text arrives messy, names TYPED LIKE THIS, emails Typed Like That. Two functions fix the case in one move:
=UPPER(A2) makes every letter CAPITAL
=LOWER(A2) makes every letter smallWith hello in A2, =UPPER(A2) shows HELLO. With HeLLo there, =LOWER(A2) shows hello. Letters that are already in the right case stay put; digits, spaces and punctuation pass through untouched, there's no "capital 7".
Important: like every formula, these don't change the original cell. A2 keeps its messy text; the cleaned-up version appears where the formula lives. That's a feature, the raw data stays safe.
Both work on quoted text too: =UPPER("excel") gives EXCEL. And since their results are text, they snap together with & from last lesson.
Challenge
BeginnerTwo messy entries need their case fixed: A2 should be shouted, A3 should be whispered.
- In
B2: the text ofA2in ALL CAPITALS - In
B3: the text ofA3in all small letters
The texts change between tests, reference the cells.
Try it yourself
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Raw | ||||||
| 2 | make me loud | ||||||
| 3 | MAKE ME QUIET | ||||||
| 4 | |||||||
| 5 | |||||||
| 6 | |||||||
| 7 | |||||||
| 8 | |||||||
| 9 | |||||||
| 10 | |||||||
| 11 | |||||||
| 12 | |||||||
| 13 | |||||||
| 14 |
Test yourselfThis lesson includes a short quiz. Start the lesson to answer it and track your progress.
All lessons in Fundamentals
1Meet the Spreadsheet
What Is a Spreadsheet?Cells and ReferencesYour First CellsRows, Columns and the GridRecap: Meet the Grid2Entering Data
Text and NumbersBuilding a Small TableEditing and Clearing CellsNumbers That Mean SomethingRecap: Entering Data3Your First Formula
What Is a Formula?Writing a FormulaFormulas with CellsArithmetic OperatorsOrder of OperationsRecap: First Formulas6Working with Text
Joining TextUPPER and LOWERMeasuring Text with LENLEFT, RIGHT and MIDRecap: Working with Text