easyPadini · textNew
Extract the department code from a Padini SKU
Column A holds Padini SKU codes in the fixed format PDN-<3-letter dept code>-<3-digit item number>, e.g. PDN-MEN-042. Every code follows this exact shape. Write formulas in B1:B2 that pull out just the 3-letter department code for each row.
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | PDN-MEN-042 | |
| 2 | PDN-KID-018 |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
B1
| A | B | |
|---|---|---|
| 1 | PDN-MEN-042 | |
| 2 | PDN-KID-018 |