Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jig Bhakta
 
Posts: n/a
Default Issues with Word Wrapping in cells after a number of characters

I am using Excel 2000. I have word wrapping turned on in Excel for a cell
and after reaching a certain amount of characters, word wrapping stops
working. Does anyone know of a fix for this?

Thanks,
Jig.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

What is the number of characters? Look in help for specifications, excel can
only display about 1024 characters in a cell


Regards,

Peo Sjoblom

"Jig Bhakta" wrote:

I am using Excel 2000. I have word wrapping turned on in Excel for a cell
and after reaching a certain amount of characters, word wrapping stops
working. Does anyone know of a fix for this?

Thanks,
Jig.

  #3   Report Post  
Jig Bhakta
 
Posts: n/a
Default

It seems that at around 1077 characters (could be less), Excel wont wrap the
text...is there any fix to this? New version of Excel?

"Peo Sjoblom" wrote:

What is the number of characters? Look in help for specifications, excel can
only display about 1024 characters in a cell


Regards,

Peo Sjoblom

"Jig Bhakta" wrote:

I am using Excel 2000. I have word wrapping turned on in Excel for a cell
and after reaching a certain amount of characters, word wrapping stops
working. Does anyone know of a fix for this?

Thanks,
Jig.

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

That 1024 limit can be extended by adding alt-enters (to force a new line in the
cell) every 80-100 characters.

And it usually fixes the problem that the text just seems to disappear....

(But you may have to adjust the rowheight manually.)

Jig Bhakta wrote:

It seems that at around 1077 characters (could be less), Excel wont wrap the
text...is there any fix to this? New version of Excel?

"Peo Sjoblom" wrote:

What is the number of characters? Look in help for specifications, excel can
only display about 1024 characters in a cell


Regards,

Peo Sjoblom

"Jig Bhakta" wrote:

I am using Excel 2000. I have word wrapping turned on in Excel for a cell
and after reaching a certain amount of characters, word wrapping stops
working. Does anyone know of a fix for this?

Thanks,
Jig.


--

Dave Peterson
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
how 2 Count number of cells that have specific condition format? daveydavey Excel Worksheet Functions 2 May 4th 05 02:06 PM
Return number of cells filled LMB New Users to Excel 3 April 29th 05 02:55 AM
Counting the number cells between two dates Dave Excel Discussion (Misc queries) 3 March 16th 05 02:30 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
only include cells beginning with specified character or number Spunky Excel Worksheet Functions 3 November 23rd 04 04:38 PM


All times are GMT +1. The time now is 11:39 AM.

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

About Us

"It's about Microsoft Excel"