#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Wrapping text

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Wrapping text

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrapping text D. Hudson Excel Worksheet Functions 5 February 15th 08 11:28 PM
Wrapping Text Karen Excel Discussion (Misc queries) 2 May 10th 07 11:52 PM
text wrapping when text is pasted in excel psipg Excel Discussion (Misc queries) 2 December 5th 06 07:25 PM
I am using wrap text in excel, so why isn't all my text wrapping? GatorDawg123 Excel Discussion (Misc queries) 2 May 6th 06 05:52 PM
wrapping text from one row to the next blazon Excel Discussion (Misc queries) 4 September 22nd 05 08:47 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"