Extract Image Extension
As an Etsy seller, I manage many product images. I need to quickly get the last 3 characters of each filename to check if it is a common image format like 'jpg' or 'png' before uploading to ensure compatibility and proper display on my shop.
=RIGHT(A2,3) 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 filename, and `3` specifies that you want to extract the last three characters from that filename. This effectively isolates common 3-character file extensions like 'jpg', 'png', or 'gif'.
Data Setup
| Filename | Product ID |
|---|---|
| product_image_01.jpg | P101 |
| listing_photo_main.png | P102 |
| item_preview.gif | P103 |
| my_design.jpeg | P104 |
| logo.svg | P105 |
Step-by-Step Guide
Open your Excel spreadsheet containing your image filenames.
Assume your filenames are listed in Column A, starting from cell A2 (e.g., 'product_photo_01.jpg').
In cell B2, type the formula: `=RIGHT(A2,3)`.
Press Enter. This will extract the last three characters from the filename in A2.
Drag the fill handle (the small square at the bottom-right corner of cell B2) down to apply the formula to all other filenames in Column A.