RIGHT / Print on Demand
Get Design ID from Filename
I need the last 6 characters of the file name to match the artwork with the order.
formula.xlsx
=RIGHT(A2, 6) How it works: The RIGHT function extracts a specified number of characters from the end (right side) of a text string. In this scenario, `A2` refers to the cell containing the filename, and `6` specifies that we want to extract the last 6 characters, which represent the unique design ID for order matching with customer orders.
Data Setup
| Filename | Order Status |
|---|---|
| T-Shirt_Design_Summer_2023_ABC123.png | Pending |
| Mug_Pattern_Floral_XYZ789.jpg | Processing |
| Hoodie_Graphic_Abstract_PQR456.jpeg | Shipped |
Step-by-Step Guide
1
Identify the column containing the filenames (e.g., Column A).
2
In an adjacent empty cell (e.g., B2), type the formula `=RIGHT(A2, 6)`.
3
Press Enter to see the extracted design ID.
4
Drag the fill handle down to apply the formula to all other filenames in your list.