mediumFoodpanda · text
Extract the outlet code from an order ID
Column A holds Foodpanda order IDs in the format FP-<outlet code>-<order number>, e.g. FP-KUL-88213. The outlet code isn't always the same length. Write formulas in B1:B2 that extract just the outlet code — the text between the two hyphens — for each row.
Starting grid
A1
| A | B | |
|---|---|---|
| 1 | FP-KUL-88213 | |
| 2 | FP-SG-44710 |
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 | FP-KUL-88213 | |
| 2 | FP-SG-44710 |