Excel - eBay Gallery Concatenate Image Names - Episode 1865
2,316 views · Published 3 March 2014 · 4:46 · Indexed 18 October 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: How to Create a String of Image Names for eBay Media Gallery | Excel VBA Solution | MrExcel Podcast. Welcome back to another episode of the MrExcel podcast. In today's episode, we will be tackling a common issue faced by eBay power sellers - how to create a string of image names for the media gallery. This can be a tedious and time-consuming task, especially when there are multiple images and varying numbers of images for each listing. But fear not, I have a solution for you. I recently spoke with Mike Girvin about this issue and we thought it would be a great topic for a dueling Excel podcast. After some trial and error, I came up with a formula that can generate the string of image names by concatenating the base name with the row numbers and the file extension. However, there was one small issue with extra quotes that needed to be resolved. I tried using the text function, but couldn't quite get it to work. So, I turned to my trusty VBA skills to come up with a solution. Before we dive into the VBA code, there are a few things to note. Firstly, if your Excel file is saved with the .xlsx extension, you will need to save it as a different file type (such as .xlsm or .xlsb) in order to enable macros. Secondly, if you are new to macros, make sure to adjust your security settings to allow them. Now, let's take a look at the VBA code. We will be using a function called Gallery, which takes two inputs - the base text and the number of times to repeat. The function will then generate the string of image names by concatenating the base text with the row numbers and the file extension. To get rid of the extra semicolon at the end, we use the Left function to trim the string. This function works perfectly and can be used for both the main image and the media gallery. However, I am always open to finding a more efficient solution. So, I am eager to hear your thoughts and suggestions in the YouTube comments. Perhaps there is a way to achieve this without using VBA, using the more funky .add-in or the mconcat function. I have not had much success with these options, but I am always willing to learn and improve. I hope this episode has been helpful for all the eBay power sellers out there. Don't forget to like, comment, and subscribe to our channel for more Excel tips and tricks. And as always, thank you for tuning in to the MrExcel podcast. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) eBay Gallery Multiple Image File Name Concatenate (00:12) The Struggle of Ebay Power Sellers (00:29) The Main Image and Media Gallery (00:47) Building the String (01:02) Possible Solution with VBA (02:08) File Type and Security Settings (03:37) Using the Gallery Function (04:06) Seeking Alternative Solutions (04:26) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Concatenate in Excel eBay power sellers Excel file extensions Excel formulas M CONCATE add-in Macros in Excel Media gallery VBA programming YouTube comments Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153690/ Dale needs to upload listings to eBay. One of the tough fields is the Gallery field, where the names of several images need to be in a single cell separated by semi-colons (Bill1.jpg;Bill2.jpg;Bill3.jpg). Given two cells that contain the image prefix and the number of images, can an Excel formula generate this gallery list? It feels like there should be an array formula to do this, but I had to resort to a VBA user defined function to solve the problem.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920