Level 2TextPractice, 3 min
LEFT, RIGHT and &
The task
SKUs look like NW-2291-BLU: region first, color last. In B2, build a short code: the first 2 characters, a dash, then the last 3 characters. Join pieces with
&.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | |
|---|---|---|
| 1 | SKU | Short code |
| 2 | NW-2291-BLU | |
| 3 | SE-0457-GRN |