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
Extract a lot number from a messy code
The situation
Warehouse barcodes bundle the SKU and the lot number into one string, and the SKU part is not always the same length. Quality control needs the five-digit lot on its own to trace a recall, and counting characters will not survive the second scan.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Barcode | Lot number | |||
| 2 | HW-4820/LOT-77341-A | ||||
| 3 | PL-1175/LOT-80126-B | ||||
| 4 | EL-90431/LOT-64509-A | ||||
| 5 | GR-226/LOT-71880-C | ||||
| 6 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- IntermediateText Functions
Pull the year out of an order code with MID
Extract characters from the middle of a text value.
MID
7 min25 points - BeginnerText Functions
Find where a word starts with SEARCH
Locate a keyword inside a longer description without worrying about capitals.
SEARCH
5 min15 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