Extract Variant ID from SKU
As a dropshipper, I frequently receive supplier inventory lists where the unique variant ID is embedded as the last 5 digits of a longer SKU string. I need to extract these last 5 digits to accurately map products to my internal inventory system and ensure correct order fulfillment.
=RIGHT(A2, 5) How it works: The RIGHT function extracts a specified number of characters from the end of a text string. In this formula, `A2` refers to the cell containing the full supplier SKU. The number `5` indicates that you want to extract the last five characters from that SKU, which in this scenario, represents the unique Variant ID needed for inventory mapping.
Data Setup
| Supplier SKU | Product Name |
|---|---|
| PROD-ABC-12345 | Red Widget |
| ITEM-XYZ-67890 | Blue Gadget |
| SKU-DEF-54321 | Green Doodad |
| VAR-GHI-98765 | Yellow Thingamajig |
Step-by-Step Guide
Select the cell where you want the extracted Variant ID to appear (e.g., B2).
Type the formula: `=RIGHT(A2, 5)` into the selected cell.
Press Enter.
Drag the fill handle (the small square at the bottom-right corner of cell B2) down to apply the formula to the rest of your SKUs in column A.