Forum Discussion
Adding text from a cell to an image
I have a list of product names that is huge in a column on the spreadsheet.
I want to add the text to the same image over and over again to create a new image with the same picture but a different product name.
Assuming I have 100,000 product names I want 100,000 images with the same picture but a different product name based on each cell - A1, A2, A3, etc.
I thought about mail merge but I need to add addresses; is there a simpler way?
Grateful for any help!
John
1 Reply
- Can you perhaps upload a sanitized version of your file?
With -say- 5 made-up product names in the exact same sheet as where you now have 100,000 of them and a separate sheet on which you place the picture and the text you want below the picture and then format the cells just the way you like.
