Practice by topic / Excel / Text Functions
Imported data is messy: extra spaces, inconsistent capitals, codes glued together. Text functions clean and reshape it without retyping anything. These 10 exercises build up step by step, starting with convert a name to uppercase, convert an email to lowercase, fix capitalization on a product name.
3 of 10 free · no sign-up needed · graded on the formula you write
A1 holds a name in mixed case. Write a formula in A2 that converts it entirely to uppercase using UPPER.
| A | |
|---|---|
| 1 | john smith |
| 2 | ? |
Use =UPPER(A1).
Right — UPPER converts every letter to its capital form.
Expected result in A2: JOHN SMITH
A1 holds an email address with inconsistent casing. Write a formula in A2 that converts it entirely to lowercase using LOWER.
Use =LOWER(A1).
Good — LOWER is standard practice before comparing or storing email addresses.
Expected result in A2: [email protected]
A1 holds a product name typed in all lowercase. Write a formula in A2 that converts it to proper title case using PROPER.
| A | |
|---|---|
| 1 | wireless mouse |
| 2 | ? |
Use =PROPER(A1).
Right — PROPER capitalizes the first letter of each word.
Expected result in A2: Wireless Mouse
A1 holds warning text in normal case. Write a formula in A2 that converts it to all caps using UPPER.
| A | |
|---|---|
| 1 | handle with care |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a city name typed in all caps. Write a formula in A2 that converts it to proper case using PROPER.
| A | |
|---|---|
| 1 | SAN FRANCISCO |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a country code in mixed case. Write a formula in A2 that converts it to lowercase using LOWER.
| A | |
|---|---|
| 1 | Us |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a book title typed in all lowercase. Write a formula in A2 that converts it to proper case using PROPER.
| A | |
|---|---|
| 1 | the great gatsby |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a state abbreviation typed in lowercase. Write a formula in A2 that converts it to uppercase using UPPER.
| A | |
|---|---|
| 1 | tx |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a search query typed with mixed case. Write a formula in A2 that converts it to lowercase using LOWER for consistent matching.
| A | |
|---|---|
| 1 | Best Pizza NYC |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →A1 holds a customer name typed in all caps. Write a formula in A2 that converts it to proper case using PROPER.
| A | |
|---|---|
| 1 | MARIA GARCIA |
| 2 | ? |
Solution and instant grading: open it in the practice app (use one of your 20 free picks, or Pro).
Try it in the live spreadsheet →