Paste Loses Characters

[Guest]

When I try to copy a column of about 80 rows of data with quite a bit of
wrapped text inside each cell and paste into another worksheet, the contents
of the cells are truncated. What can be done to fix this problem?

Thanks.

 

[Dave Peterson]

Make sure that both workbooks are open in the same instance of excel--not
separate instances.

Close one workbook (and that instance of excel)
In the remaining instance
file|open yourworkbook.xls

then do the copy|paste.

 

[Guest]

Dave,

Thanks for your quick response. Never knew that mattered.