Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 3/6

UPPER, LOWER, PROPER

Exercise 1 of 3

In B2, turn the name into capitals.

About this lesson

UPPER, LOWER and PROPER change text to capitals, to small letters, or to a capital at the start of each word.

In this lesson

  1. In B2, turn the name into capitals.
  2. In B2, fix the name so each word starts with a capital.
  3. In B2, turn the email into small letters.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.