I think I figured out how to fix the problem. I opened the .csv file in notepad++. When I did that, I could still see CR and LF characters (even after using wrap text). I was able to remove the CR and LF characters in notepad++ then continue my downstream processing. Not sure if there is a way to do this in Excel - but for now, my problem is resolved. Thanks!!
Quote:
Originally Posted by TimR1316
Thanks, Claus. I neglected to mention that I had tried that. It looks fine - but my down stream processes still think there's something there causing the line break.
Maybe there's something else causing the downstream problem, but this seems to happen frequently when dealing with text like this. I can normally fix it manually, but there are so many cells like this, it would take me forever to fix them.
Thanks!!
Tim
|