Copy sheets with more than 255 chars in a cell?

C

Chem Mitch

I have MS Excel 2002 SP2. It truncates data in cells to 255 when copying a
sheet. Does a later version copy the entire contents of each cell?
 
D

Dave Peterson

xl2003 still truncates.

But I can go back and copy the cells and paste the formulas to get those long
values.
 

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

Get error message about copying cells with more than 255 characte. 2
Cell data entering slow! 0
Need Help with a VBA subroutine 0
Memo Field is truncating to 255 Chars 6
Pasting a cell into bookmarked table from excel vba 1
Bugs in Office 2019 0
Cell copy 2
Copy entire row from another sheet onto first sheet if a unique text matches 1

Top