Practice challenge
Extract the middle SKU segment
#22
3 attempts remaining
IntermediateText cleanupTarget C2
Product SKUs use a fixed format where characters 5 through 7 identify the line.
Write a formula for C2 that extracts the three-character line code from A2.
Extract the middle SKU segment
Swipe horizontally to view the full table.
| A | B | C | |
|---|---|---|---|
| # | SKU | Product | Line code |
| 2 | BOX-TEA-184 | Tea box | blank |
| 3 | BOX-MUG-220 | Mug box | blank |
| 4 | BOX-KIT-911 | Kit box | blank |