How can I copy more than 255 characters in a cell without truncati

  • Thread starter Thread starter Gary Grung
  • Start date Start date
G

Gary Grung

Hi

How can I (without the use of VBA) copy a large sheet where several cells
have more than 255 characters, without truncating the characters to a max of
255?

Thanks

Excel 2002 SP3
(This cannot be changed)
 
Copy the sheet and allow the truncation.

Then go back and copy all the cells and then paste over the new sheet.

(Same thing in vba, too!)
 

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
find and Select cells 1
How do I get more than 255 characters into a cell? 3
How do I copy more than 255 characters per cell? 2
Why can't I get more than 255 characters in one cell in Excel 07? 1
Why is Excel truncating my text to 255 characters? 2
Excel character limitations 1
#### error if cell has more than 255 characters 1

Back
Top