Thanks so much for taking the time to do that. It works perfectly for one block of text. When I tried to copy the multiple blocks of text into the spreadsheet and run the macro, it would not work, as I think it was meant only for one group of text items. I am going to have about 200-300 groups of items like this with the same headers.