Truncation of text when Copy/Paste to another worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003.

I'm attempting to help a friend speed up a process. In collection of
information from several workers, all information was put into one workbook-
several sheet tabs. He would like to copy/paste areas of text from the
several sheets to a new mater workbook but the text is being truncated at
about 100 characters (+or-).

Is there a limit in the c&p feature? Or, could there be a setting in one of
the workbooks that is not allowing the full text to be c&p?

Thanks for any help!
 
My mistake- I believe it is in relation to a 255 character rule. Is there a
way around this?
 
This only happens when you have 2 separate instances of Excel running at once.

Copying between open workbooks in a single instance does not truncate the data.

Close one instance, open both workbooks in the single instance and try again.


Gord Dibben MS Excel MVP
 
Hi,

This can happen based on the type of copy command you use -
1. If you copy a sheet from one workbook to the other using a Ctrl Drag
method data will be truncated to 255 characters.

2. If you click the top left corner of the spreadsheet to select the entire
sheet and use a Edit, Copy command and them move to the other workbook and
paste, there will be no truncation.
 

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
Excel Move or Copy Stopped Working? 0
Intentionally truncating text characters 2
Cannot copy worksheet to another file 2
Truncated text when copying text from one excel doc to another 2
Copy Past Values 14
Why is Excel truncating my text to 255 characters? 2
Format Copy to Worksheet 1

Back
Top