Word and Excel Merge: 255-character limit problem

[Brian Siano]

I have an Excel spreadsheet which has several cells which contain text which
exceeds 255 characters in length. When I merge this into Word, however, some
of these fields are truncated at 255 characters. I cannot understand why this
happens with only some of these fields, which are otherwise formatted
identically.

Is there a fix or a workaround for this problem?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?QnJpYW4gU2lhbm8=?=,

Merging to Excel cells with more than 255 characters can be tricky. When mail
merge was originally developed, an Excel couldn't hold more than 255
characters...

Which version of Office are you using? Do the cells being truncated hold any
characters the others do not? I'm mostly thinking about something like Alt+Enter
to generate a line break in an Excel cell, or something of that nature.

I have an Excel spreadsheet which has several cells which contain text which
exceeds 255 characters in length. When I merge this into Word, however, some
of these fields are truncated at 255 characters. I cannot understand why this
happens with only some of these fields, which are otherwise formatted
identically.

Is there a fix or a workaround for this problem?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail