By default, Excel's limit for copy/paste operations is 255 characters.
To work around this I usually enter EditMode (F2) to paste data copied
from web pages (or any other content containing html/php). Sometimes,
I'll paste in Notepad first, then edit as required, then copy/paste to
a cell AFTER entering EditMode.

Any sheets being copied also lose any characters beyond the 255 limit.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion