Inserting cell information into wordart ~ text effect "button"

So I need to laser engrave 1" round glass with sample identifiers on the outside of the glass. Currently we are manually entering sample names into a word file (see picture) and then sending the print job to the laser engraver.Capture1.JPG

This is slow and prone to user error. I would like to reference cell data within each of the "wordart". The problem I am running into is the word art text transform "button" requires me to hit enter and go to the next line but I cant seem to make that work within excel. Any further direction would be much appreciated.


-Matt

So I can reference data inside of wordart. The problem is I cant seem to reference all the data.

If you look at the first "word art"... "Cell A1" and "Cell B1" are seperated by a line in the middle. I need to essentially Reference cell a1, hit enter to get a new line, hit enter again because i dont need anything in the middle and then reference cell B1.

Hmm. My reply didnt appear to go through.

That is what I was looking for. Thank you.

The next problem is how do i concatenate 2 cells into 1 with 3 lines within the new cell.

Ex. How do I turn AAA 001, Countertop into
AAA 001
""
Countertop

Ah. I appear to have figured it out.

= A1 & Char(10) & Char(10) & B1

thank you for your help