You're welcome. Thanks for the rep.


I don't use Notepad++ so I can't offer an opinion. Another thought is that you get quotes added at the beginning and end because there are commas in the text and Notepad++ is trying to maintain the integrity of the cell contents.

Interestingly, I only see 6 carriage returns (char(10)) in both Excel and Word yet when I did the COUNTIF in Excel it showed 9. Confusing.


Regards, TMS