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