Hi,

Is there word wrap functionality in excel?

If in cell A1 I have a string of text say 5000 chars long,
Is there functionality in excel to wrap this text around when the text
reaches the vertical page break?

Thanks,
DK

"David Kennedy" <dkennedy85@hotmail.com> wrote in message
news:use8PWeMIHA.484@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> Is there word wrap functionality in excel?
>
> If in cell A1 I have a string of text say 5000 chars long,
> Is there functionality in excel to wrap this text around when the text
> reaches the vertical page break?


You can certainly wrap text in a cell or a group of merged cells, but not
otherwise AFAIK....

David

If you read Excel help on specifications you will find that a cell can hold
32767 characters but only about 1000 will be visible or can be printed.

You can increase this limit by adding linefeeds every 80-100 characters by Alt +
ENTER but there still is some limit to the amount of text that will show or be
printed.

In answer to your original question, No, you cannot wrap text in a cell across
pages.

If you were to merge some cells, a page-break can occur in the middle of the
merged cells but merging cells won't get you any more text than a single cell.


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 17:46:17 -0000, "David Kennedy" <dkennedy85@hotmail.com>
wrote:

>Hi,
>
>Is there word wrap functionality in excel?
>
>If in cell A1 I have a string of text say 5000 chars long,
>Is there functionality in excel to wrap this text around when the text
>reaches the vertical page break?
>
>Thanks,
>DK
>
>