IntermediateData Cleaning
Standardise messy codes with TRIM and UPPER
Clean inconsistent spacing and casing so values can be matched.
7 min25 points
Check code length with LEN
The situation
Harbor Supply's product codes should always be exactly nine characters. A recent import added some malformed rows, and you need to spot them.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Product code | Length | |||
| 2 | HSC-04182 | ||||
| 3 | HSC-1190 | ||||
| 4 | HSC-77213 | ||||
| 5 | HSC-0043 | ||||
| 6 |
Functions in this exercise
- LEN — Counts the characters in a text value, spaces included.
Who this is for
Recommended next
Related exercises
- 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 - IntermediateData Cleaning
Standardise messy codes with TRIM and UPPER
Clean inconsistent spacing and casing so values can be matched.
7 min25 points - BeginnerText Functions
Build a mailing address with TEXTJOIN
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
6 min15 points