Word and Excel Merge: 255-character limit problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Siano - 15 Nov 2004 14:13 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 16 Nov 2004 17:40 GMT

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
[quoted text clipped - 3 lines]
>
> 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 :-)

Reply to this Message