Adding text from a cell to an image

Copper Contributor

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.