ExcelBanter - Wrapping text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Wrapping text (https://www.excelbanter.com/excel-discussion-misc-queries/223747-wrapping-text.html)

I imported text from a database that is in a worksheet format and when I
paste it into Excel worksheet it does not include all the text though I
wrapped it. Does anyone have a suggestion on what I am not doing to include
all the text? It might be that the version I have might be limited to so
much characters in a cell. I have Excel 2003.

Excel 2003 specs state you can enter 32767 characters in a cell.

However only 1024 of these will be visible in the cell.

The workaround to increase the limit is to create a linefeed every 100 or so
characters.

Use Alt + Enter to produce a linefeed.

Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 08:38:14 -0700, Charlie2
wrote:

I imported text from a database that is in a worksheet format and when I
paste it into Excel worksheet it does not include all the text though I
wrapped it. Does anyone have a suggestion on what I am not doing to include
all the text? It might be that the version I have might be limited to so
much characters in a cell. I have Excel 2003.