Hi.

I have a laptop display extended to a VDU so I have two instances of Excel open so that I can view two Excel files at the same time, rather than the usual way of opening both files in a single instance of Excel (in which case you can only view one worksheet at a time and have to switch between Windows).

Copying and pasting cells from a worksheet in one instance of Excel to a worksheet in the other instance of Excel results in the text being truncated. Excel isn't consistent and can shorten the text to 34 characters, 42 characters etc.

Copying and pasting cells within the same worksheet, pasting to another worksheet but within the same file or pasting to another worksheet in a different file but in the same instance of Excel doesn't appear to be a problem. I have ensured that the cells are of the same type, i.e. Text.

Has anyone else experienced this problem and more importantly, do you know a solution? I would really like to keep both worksheets in view at the same time so need two instances of Excel open. Is this problem just a characteristic of Excel and has no solution?

Thanks in advance,

Paul