I'm sure there's an easy way to do this, I'm just not thinking of it. I need to generate a large number of random names and then copy them into a single column in another file. I have an excel file with all the first names in one column and all the last names in the next column. Each column has a column of =rand() next to it. When I need to generate a new list of names, I just sort each column by their =rand() column. So it looks like this: I can then sort, and then highlight columns B and C and copy them and get my list of randomly matched first and last names. The problem is that I then have to paste these names into a new column in another Excel spreadsheet, but when I do, I need the first and last names together in the same cell, so that it only spans one column rather than two. So obviously when I have them copied, if I paste them how they are they will paste into two columns. So I thought that I could first paste them into Notepad and then that would strip all the formatting from them, and then I could copy them again from notepad and paste them into Excel and they would all appear in one column, but that didn't work. The column formatting apparently carries into Notepad and then when I copy and paste them from Notepad into Excel, they still go into two columns. I tried highlighting one column first and pasting them that way, thinking maybe Excel would "force" them into one column since I had one column selected, but that didn't work, either. So how do I do this? I don't want to do a cell merge because that just makes it look like one column rather than actually being in one column. In other words, I need them to look like this: Rather than this: Thanks.