Ok just give me a little time. I've got some family events tonight and then 1 thing to do tomorrow but it should not be too hard to write this out.

I will write a script that will go through all workbooks in a folder (You can specify the folder.) Then it will go through columns C and D and remove all carriage returns. (The starting row may be different for each workbook) The returns will be changed into a comma. Each of these workbooks will be saved with the same book name and left in the folder.) I should be able to have it done before the end of the week.

Thanks