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
Build a product code with CONCAT
The situation
Harbor Supply is loading a new supplier's catalogue into the warehouse system, which expects one SKU per line in the form HW-4820. The supplier sent the category prefix and the item number in separate columns.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Prefix | Item | SKU | ||
| 2 | HW | 4820.00 | |||
| 3 | PL | 1175.00 | |||
| 4 | EL | 9043.00 | |||
| 5 | GR | 2266.00 | |||
| 6 | SF | 7710.00 | |||
| 7 |
Functions in this exercise
- CONCAT — Joins text values together into one.
Who this is for
Recommended next
Related exercises
- BeginnerText Functions
Build a mailing address with TEXTJOIN
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
6 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
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points