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
Pull the year out of an order code with MID
The situation
Harbor Supply's order codes embed the year, but there is no separate year column and finance wants to split the file by fiscal year.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order code | Year | |||
| 2 | ORD-2026-1041 | ||||
| 3 | ORD-2025-0987 | ||||
| 4 | ORD-2026-1042 | ||||
| 5 | |||||
| 6 |
Functions in this exercise
- MID — Returns characters from the middle of a text value, given a start point.
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