Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Paste Loses Characters

Dave,

Thanks for your quick response. Never knew that mattered.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cut/paste cells based on text color or certain characters michaelberrier Excel Discussion (Misc queries) 8 February 3rd 07 03:46 PM
Excel workspace loses formatting Snarf Excel Discussion (Misc queries) 3 March 16th 06 03:47 PM
Lotus 123 import to Excel loses 2 text characters mackie99 Excel Discussion (Misc queries) 2 October 20th 05 04:23 PM
Excel won't allow me to paste certain Turkish characters. neil Excel Discussion (Misc queries) 1 July 4th 05 02:35 PM
Hyperlink loses reference Jami's Mom Excel Worksheet Functions 0 December 16th 04 08:23 PM


All times are GMT +1. The time now is 12:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"