Excel practice · Text Functions

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

  1. Standardize text to all uppercase
  2. Standardize an email to lowercase
  3. Format a name with proper capitalization
  4. Find an exact, case-sensitive match inside text
  5. Join a list of items into one line of text

The exercises

1. Standardize text to all uppercase Easy

A product code was typed in lowercase. Convert it to uppercase so it matches the standard format.

AB
1Raw codeab-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.

2. Standardize an email to lowercase Easy

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.

AB
1Customer IDC-2201
2Raw emailJane.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.

3. Format a name with proper capitalization Easy

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.

ABC
1Customer IDC-2201jane 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.

5. Join a list of items into one line of text Medium

Combine a list of toppings into one comma-separated line, skipping any that are blank.

AB
1Topping 1Cheese
2Topping 2
3Topping 3Pepperoni
4Topping 4Olives
5Combined 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 →

More text functions practice

All Excel practice exercises · Excel test prep