How do I copy more than 255 characters per cell?

G

Guest

Is there a way to copy more than 255 characters in a cell when copying into a
new workbook?
 
D

Dave Peterson

Make sure both workbooks are opened in the same instance of excel.

Open the first workbook anyway you want.
File|open the second workbook

Then do the copy|paste.
 
J

Jim Rech

The error message you get when you copy an entire sheet with this issue to
another workbook suggests that you copy the cells instead of or in addition
to copying the sheet. Doesn't this work?

This problem was fixed in Excel 2007, btw.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I copy more than 255 characters in a cell without truncati 1
How do I get more than 255 characters into a cell? 3
Why can't I get more than 255 characters in one cell in Excel 07? 1
Word wrap with > 255 characters 2
Excel character limitations 1
cell contents truncated 3
Cannot copy cell 5

Top