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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I copy more than 255 characters in a cell without truncati 1
Word macro that can call cells out of Excel for a find and replace 0
merge 3 workbooks (and all coniciding worksheets) into 1 master wb 0
Unlink cells- how? 0
255 Charactor per cell 2
Tracking Changes Column Limit 2
Exporting Access to Excel - Characters per cell limitation 0
Find text in cell and copy from 4 characters in front of the found text. 2

Top