Forum Discussion
copying from excel to text goes wrong, how to solve
As seen in the screenshot, I selected the blocks on the left using ctrl and shift. If pasted in excel, it is all going well, but when copied to another textfile (or the sent to box of my email), it g...
Hi Friso,
I guess that's not a bug, that's by design. If you open clipboard you'll see what Excel saves in it the entire continuous range.
If you paste back to Excel it somehow recognizes what the selection is not adjacent, i don't know how it works exactly. But Windows clipboard has no such information and paste everything.
From my memory there were some VBA scripts to solve the issue, google may help.