Text Functions
Beginner

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.

Learning Objectives:

  • Learn case conversion functions
  • Understand text formatting
  • Practice data standardization
Hints

Solve without hints for +5 XP

Interactive Spreadsheet

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.

ABCD
1OriginalUPPERCASElowercaseProper Case
2john SMITH
3MARY jones
4tom WILSON
What this exercise teaches (contains the answer)

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

Functions used here