Chapter 5 Cleaning up text ・ MISSION 20

Mission 20: Remove extra spaces

📋 Mission list

Task

In B2:B5, show the customer names without spaces at the start and end, and with repeated spaces reduced to one.

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 5 ・ MISSION 20

Remove extra spaces

In B2:B5, show the customer names without spaces at the start and end, and with repeated spaces reduced to one.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =TRIM(A2)

TRIM removes spaces at both ends and reduces repeated spaces inside to one. Clean names before matching them or using VLOOKUP, so values that look the same also match.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).