ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste Loses Characters (https://www.excelbanter.com/excel-discussion-misc-queries/130403-paste-loses-characters.html)

oolsen

Paste Loses Characters
 
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

Paste Loses Characters
 
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.

oolsen wrote:

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

oolsen

Paste Loses Characters
 
Dave,

Thanks for your quick response. Never knew that mattered.





All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com