UPPER to build a code
Turn a name and a number into a consistent upper-case reference.
Task:
Each branch needs a short code: the first three letters of the town in capitals, a hyphen, then its branch number — for example LEE-104. Build it in C2:C6.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of UPPER, LOWER, PROPER
0/3The same formula in the other shapes it takes at work.
- UPPER, LOWER, and PROPER Functions
Change the case of text using case conversion functions.
CoreBeginner - LOWER to make emails comparable
Normalise case before you compare, count or remove duplicates.
Beginner - UPPER to build a code
Turn a name and a number into a consistent upper-case reference.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Town | Branch no. | Code |
| 2 | Leeds | 104 | |
| 3 | york | 211 | |
| 4 | Bristol | 87 | |
| 5 | cardiff | 330 | |
| 6 | Exeter | 59 |
What this exercise teachesMay contain the answer
Codes are compared and looked up, so they have to be consistent; "yor-211" and "YOR-211" would not match a case-sensitive system. Forcing upper case inside the formula means the code is right however the source was typed.