TRIM practice

TRIM removes leading, trailing and repeated spaces from a text. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

TRIM(text)

What people get wrong

Stray spaces are the most common reason a lookup fails on a value that looks right.

Google Sheets exercise that use TRIM

• Tidy up pasted namesLevel 5Pro

Often used together with: PROPER