Drew
This is a limitation in Excel. If you try to copy the contents of a cell to
another, it will give you the 256 character warning. Prior to Office 2002, I
believe that Excel had a 256 character cell limit (i.e. you could not enter
more than 256 characters). That limitation was removed but you can still
only copy/paste the 256 characters though.
terry
message : Yes, I realize this is a WORD newsgroup and I posted here because I'm
: interested in the Paste Special behavior of WORD. I posted to the Excel
: group last week but there were no responses.
:
: So, are you saying there is no way to change this behavior and it is a
: function of Excel, not Word?
:
: By the way, there is no warning with paste special into Word. You just
get
: truncated data.
:
: - Drew
:
: "TF" wrote:
:
: > Well this is a WORD newsgroup. Excel has its own newsgroup.
: >
: > But the 255 character limit for copy/paste of a cell is a characteristic
of
: > Excel: at least it warns you of the limitation!
: >
: > --
: > Terry Farrell - Word MVP
:
: >
: > message : > :I copied a range of cells from Excel, some of which contain more than
255
: > : text characters. When I used paste special to include the range as an
: > Excel
: > : worksheet object in Word, any cells that contained more than 255
: > characters
: > : are truncated to 255. Does anyone know why this happens or if there
is a
: > way
: > : to change the behavior?
: > :
: > : Thanks.
: > :
: > : - Drew
: >
: >
: >
