find and Select cells

G

Guest

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
Cannot copy cell 5
Text in Text-formatted cells changes to ### after the 255th charac 2
Microsoft Excel Cell text limits 3
Tracking Changes Column Limit 2
Get error message about copying cells with more than 255 characte. 2
Macros to count characters 5
Unlink cells- how? 0

Top