Practice challenge
Extract a product prefix
#10
3 attempts remaining
BeginnerText cleanupTarget C2
A product code starts with a three-character category prefix.
Write a formula for C2 that extracts the first three characters from the SKU.
Extract a product prefix
Swipe horizontally to view the full table.
| A | B | C | |
|---|---|---|---|
| # | SKU | Product | Prefix |
| 2 | TEA-1842 | Green tea | blank |
| 3 | MUG-2201 | Ceramic mug | blank |
| 4 | KIT-9110 | Starter kit | blank |