=A1&", "&A2&", "&A3&", "&A4&", "&A5&", "&A6&", "&A7&", "&A8&", "&A9&", "&A10 Keep repeating and replace the cell numbers with the actual. I thought there was a more automated way to do it. I know I have 2 programs I wrote at work that did something like this but don't have my notes here at home. If someone can send me the excel file I will do the leg work, verify it and then send it back. Willing to help out.