Text FunctionsBeginner

TRIM Function

Remove extra spaces from text using TRIM.

Task:

Clean up the text in column A by removing extra leading, trailing, and multiple spaces between words. Display the cleaned text in column B.

Interactive Spreadsheet

Read about TRIM

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 TRIM

0/3

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

  1. TRIM Function

    Remove extra spaces from text using TRIM.

    CoreBeginner
  2. TRIM before you compare

    Two cells that look identical, and a comparison that says they are not.

    Intermediate
  3. Measure what TRIM removes

    LEN before and after TRIM shows how dirty a column really is.

    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.

5 rows × 2 columns4 cells you fill in
AB
1Original TextCleaned Text
2 John Smith
3 Mary Jones
4Tom Wilson
5 Sarah Brown

Functions used here

What this exercise teachesMay contain the answer

The TRIM function removes extra spaces from text, leaving only single spaces between words. It's crucial for data cleaning operations.