TRIM practice

TRIM removes leading, trailing and repeated spaces from a text. Below are the 4 Excel exercises on Formuladrill 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.

Excel exercises that use TRIM

• Clean up namesLevel 4Pro
• Clean the customer namesLevel 6Free
• Sales by region with messy labelsLevel 6Pro
• Lookups that fail on stray spacesLevel 6Pro

Often used together with: PROPER, SUMIF, VLOOKUP