Should'nt happen as you described - except there is a problem with a
cell formatted as TEXT and a cell data length 512 to 1024 characters.
(the cell is displayed as ##### symbols)

From a worksheet, if you Move & create-a-copy a worksheet there is a
limit on the contents of a cell size, but Excel will tell you of this
at the time of the copy.

For a cell, or range of cells, or whole worksheet, the Copy and Paste
into a new sheet should copy all data up to 32,768 characters per
cell.

The limit on what is displayed in the cell is 1,024 characters, or 409
points of row height.

To see the full cell contents select the cell and check the formula
bar.

Test the row height problem by reducing the font size for the cell, and
remember to restore the setting afterwards



sunny pete Wrote:
launch two excel documents
Enter a long text string into any cell 500 characters
Copy the cell and paste it to any cell in the other document

Result: the pasted text is truncated losing the end of the original
text
string.

How can I fix this?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395285