Text FunctionsBeginner

UPPER, LOWER, and PROPER Functions

Change the case of text using case conversion functions.

Task:

Convert text to all uppercase in column B, all lowercase in column C, and proper case (title case) in column D.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of UPPER, LOWER, PROPER

0/3

The same formula in the other shapes it takes at work.

  1. UPPER, LOWER, and PROPER Functions

    Change the case of text using case conversion functions.

    CoreBeginner
  2. LOWER to make emails comparable

    Normalise case before you compare, count or remove duplicates.

    Beginner
  3. 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.

4 rows × 4 columns9 cells you fill in
ABCD
1OriginalUPPERCASElowercaseProper Case
2john SMITH
3MARY jones
4tom WILSON

Functions used here

What this exercise teachesMay contain the answer

Case conversion functions help standardize text data. UPPER, LOWER, and PROPER are commonly used for formatting names, titles, and other text.