I did the research and know how to get this to work on every workbook in a folder. Now it will take some time to code but I still think I dont have all the information. The last attachment contains just sample data with the only carriage returns showing in the headers. I need to know where else to have the carriage returns removed. since this code will process 50 workbooks no problem I want to write it once and make sure it is right.

Thanks