Thanks Richard, but I couldn't get your sort macro to work. I did say I was a total NOOB on vba right? I'm sure I'm doing something wrong on my end. However, I did receive another solution (in the formulas forum) using a formula to first alphabetize the list (creating a new column of data, which I was hoping to avoid), and then applying this Concat_Range macro to that. I was just hoping there was some way to modify the code above to handle everything in one fell swoop. But, thank you for your time.