3 Answers Found

I don't think it is a case of copying the carriage return but more of a caseof Word keeping formatting with the text. Word keeps formatting inparagraph markers, so if you do a PasteSpecial using Unformatted text yourresults will not have the paragraph marker.

The trouble with Excel's "Copy with Carriage Return" trouble can beverified by going into any text editor and do paste, we would get 2lines. Therefore this is not a Word formatting problem alone.Also, most text editor do not have capability to do such thing asPasteSpecial using Unformatted. Therefore, we are forced to fix theproblem at Excel side.

One other observation: if I select a cell and do copy, I get 2 lineswhen I do paste later in Word or any other text editor. But if Iselect a cell and go inside the cell, highlight the text and doCOPY...I get only 1 line when I do paste later in Word or any othertext editor. This shows that just copy a cell or copy text inside acell produced different results.