Thanks to both of you for the help. The main problem I had was I had no idea how to search for what I wanted to do, either in the help file or on Google. I must say that I was proud of my workaround. I copied the columns I wanted into a new worksheet in the order I wanted, then inserted columns containing the punctuation. I then copied the columns into Notepad, did find and replace to get rid of the tabs and to insert the spaces, and then I was left with the result I wanted. It worked perfectly, but is clearly not as elegant as the solutions you offer Still, I was happy when it worked