find and Select cells

R

Richard

Hi,

I have a rather large spreadsheet that contains cells with more than 255
characters. I want to copy this sheet into another workbook, but I receive a
message saying it is truncating the cells with more than 255 characters. How
do I get the entire sheet to copy over without any missing information?


Thank you,
 
D

Dave Peterson

One work-around: Turn it into a couple of steps.

#1. Copy the sheet (edit|Move or copy sheet)
#2. Back to the original sheet
Edit|Copy all the cells
To the copied sheet
Edit|Paste
 
Top