| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrapping Text in a cell limitations - Excel 2003
When wrapping text in a cell (Excel 2003), does the wrapping only apply to a
limited amount of characters? I notice the wrapping stops after a certain point. Is there a work around? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wrapping Text in a cell limitations - Excel 2003
It stops around 1024 characters. You can overcome it by doing Alt+Enter
periodically within the data. -- Regards, Tom Ogilvy "FLHOIT" wrote in message ... When wrapping text in a cell (Excel 2003), does the wrapping only apply to a limited amount of characters? I notice the wrapping stops after a certain point. Is there a work around? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wrapping Text in a cell limitations - Excel 2003
FLHOIT, If you type in "Excel specifications and limits" into help and look fo "Length of cell contents" you might see where your problem is at. For my version 2002 it reads: Length of cell contents (text) 32,767 characters. Only 1,024 display i a cell; all 32,767 display in the formula bar. HT -- Case ----------------------------------------------------------------------- Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454 View this thread: http://www.excelforum.com/showthread.php?threadid=47763 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wrapping Text in a cell limitations - Excel 2003
That's true, but if you use what I posted, you can exceed 1024.
-- Regards, Tom Ogilvy "Casey" wrote in message ... FLHOIT, If you type in "Excel specifications and limits" into help and look for "Length of cell contents" you might see where your problem is at. For my version 2002 it reads: Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=477635 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wrapping Text in a cell limitations - Excel 2003
Tom, Thanks for the additional info. I have used altenter alot fo formatting reasons, I did not know you could circumvent the 1024 limi by using it. I occasionally need that many characters in cell an always ended up splitting the information between cells -- Case ----------------------------------------------------------------------- Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454 View this thread: http://www.excelforum.com/showthread.php?threadid=47763 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text wrapping in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 Limitations? | Excel Discussion (Misc queries) | |||
| wrapping text autosize in excel 2003 | Excel Discussion (Misc queries) | |||
| Wrapping in Excel (fitting many lines of text in cell to print rig | Excel Discussion (Misc queries) | |||
| Wrapping text in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
