UPPER, LOWER, PROPER, FIND & TEXTJOIN practice exercises
5 graded problems with realistic data, from easy to medium.
Five more everyday text functions: three for changing letter case, one for finding a case-sensitive position, and one for joining a list with a shared delimiter. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the UPPER, LOWER, PROPER, FIND & TEXTJOIN guide first: syntax, a worked example and the mistakes people make.
In this set
- Standardize text to all uppercase
- Standardize an email to lowercase
- Format a name with proper capitalization
- Find an exact, case-sensitive match inside text
- Join a list of items into one line of text
The exercises
A product code was typed in lowercase. Convert it to uppercase so it matches the standard format.
| A | B | |
|---|---|---|
| 1 | Raw code | ab-4471 |
| 2 | ? |
Enter a formula in A2.
Show a hint
UPPER(text) converts every letter to uppercase: =UPPER(B1).
Inconsistent casing is one of the most common real data-entry problems: UPPER/LOWER/PROPER are how you force a whole column into one consistent style before comparing or matching it.
An email address was typed with mixed capitalization, stored in B2 here (row 1 just holds the customer ID). Convert it to all-lowercase, the standard format for comparing email addresses.
| A | B | |
|---|---|---|
| 1 | Customer ID | C-2201 |
| 2 | Raw email | Jane.DOE@Example.com |
| 3 | ? |
Enter a formula in A3.
Show a hint
LOWER(text) converts every letter to lowercase: =LOWER(B2).
Two emails that differ only in capitalization are the same address; LOWER is how you make that true for an exact-match lookup or a duplicate check.
A customer's name was entered in all lowercase, sitting in C1 here (column B just holds the customer ID). Format it with a capital letter starting each word.
| A | B | C | |
|---|---|---|---|
| 1 | Customer ID | C-2201 | jane doe |
| 2 | ? |
Enter a formula in A2.
Show a hint
PROPER(text) capitalizes the first letter of every word: =PROPER(C1).
PROPER is the fix for names, addresses, and titles typed in all caps or all lowercase: the display-friendly version of UPPER/LOWER.
A log line contains the text "ERROR" in all caps, mixed in with lowercase text. Find the position where the exact, capitalized "ERROR" starts.
| A | B | |
|---|---|---|
| 1 | Log line | system check: ERROR at step 4 |
| 2 | ? |
Enter a formula in A2.
Show a hint
FIND(find_text, within_text) is case-sensitive, unlike SEARCH: =FIND("ERROR",B1).
SEARCH treats "error" and "ERROR" as the same thing; FIND is the one to reach for whenever case actually matters, like telling a real ERROR flag apart from the word appearing in ordinary lowercase text.
Combine a list of toppings into one comma-separated line, skipping any that are blank.
| A | B | |
|---|---|---|
| 1 | Topping 1 | Cheese |
| 2 | Topping 2 | |
| 3 | Topping 3 | Pepperoni |
| 4 | Topping 4 | Olives |
| 5 | Combined list | ? |
Enter a formula in B5.
Show a hint
TEXTJOIN(delimiter, ignore_empty, text1, text2, ...) joins everything with the delimiter between each piece, skipping blanks when ignore_empty is TRUE: =TEXTJOIN(", ",TRUE,B1,B2,B3,B4).
Before TEXTJOIN, joining a list with a separator while skipping blanks took a clunky nested formula; TEXTJOIN does both jobs, delimiter and blank-skipping, in one function.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the UPPER, LOWER, PROPER, FIND & TEXTJOIN exercises →