Skip to content
Lesson 4/6

TRIM: remove extra spaces

Exercise 1 of 3

The name was typed with extra spaces. In B2, clean it up.

About this lesson

TRIM removes extra spaces from text, a common clean-up step for typed or pasted data.

In this lesson

  1. The name was typed with extra spaces. In B2, clean it up.
  2. In B2, work out how many extra spaces the name has.
  3. In B2, remove the extra spaces and give each word a capital, in one formula.

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.