Ok I think I have a handle on it now so is it just going to be columns C and D then? or does that differ for each workbook. It can be done either way but I will need to make sure since this will overwrite the existing file once it has "cleaned" it. So just to clarify are the carriage returns just in columns C and D or are they all over?

Thanks for your patience so far. I know you will be happy with the result.