BeginnerText Functions
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points
Strip stray spaces from item codes with TRIM
The situation
Harbor Supply's new supplier sends item codes with spaces around them — a space before, two after, sometimes both. They look identical on screen, but a lookup against the product master fails on every padded one and the receiving team has been retyping them by hand. The codes need cleaning before anything else can use them.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Raw code | Clean code | |||
| 2 | HSC-04182 | ||||
| 3 | HSC-77213 | ||||
| 4 | HSC-11904 | ||||
| 5 | HSC-33027 | ||||
| 6 |
Functions in this exercise
- TRIM — Removes the spaces before and after text, and collapses repeated spaces inside it. Syntax and example
Who this is for
Recommended next
Related exercises
- IntermediateData Cleaning
Standardise messy codes with TRIM and UPPER
Clean inconsistent spacing and casing so values can be matched.
7 min25 points - AdvancedData Cleaning
Reconcile a list with hidden spaces
Match two lists where one side has trailing spaces you cannot see.
COUNTIF · IF
12 min35 points - BeginnerText Functions
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points