Wrapping text

C

Charlie2

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Viewing text 2003 vs. 2007 6
Cannot save text wrapping in cells-must do individually 1
wrapping text in merged cells 2
Merge and Wrapping Text 3
How do I prevent a long string of text from wrapping in a text fil 1
Wrapping text 2
wrapping text in cell 3
Access 2007-Report (Text Wrapping) 2

Top