How can the number of words per cell in Excel be increased?
 

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

The limit size of a cell is 32,736 characters although you can only display
up to 256 characters. You can see all the limits using the worksheet help
menu under

Excel specifications and limits

"Joerg" wrote:

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

Hi

There is an excellent addin available from Dr Peter Grebenik which allows
you to type 32,000 characters in a cell and view them all.
It can be downloaded here
http://excelusergroup.org/media/p/2362.aspx

--
Regards
Roger Govier

"Joerg" wrote in message
...
Hi there!
I am working on an Excel spread sheet with a lot of text information.
There
appears to be maximum number of words/characters set for each cell, so
that
parts of the text information are not displayed. Regardless if I increase
the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

Add a linefeed every 100 characters.

100 charsAlt + Enter100 charsAlt + Enter.


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 03:20:02 -0700, Joerg
wrote:

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

Joel

If you actually read the help on specs and limits you would find that you
can display 1024 characters............not 256.


Gord

On Mon, 16 Mar 2009 03:39:01 -0700, Joel
wrote:

The limit size of a cell is 32,736 characters although you can only display
up to 256 characters. You can see all the limits using the worksheet help
menu under

Excel specifications and limits

"Joerg" wrote:

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

Joerg wrote:
Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg
Once the number of words in a cell becomes excessive, one approach is to
use a hyperlink to another document, perhaps Notepad, which contains all
the information you want to display for that cell.

Bill

How can the number of words per cell in Excel be increased?
 

"Gord Dibben" wrote:

Add a linefeed every 100 characters.

100 charsAlt + Enter100 charsAlt + Enter.


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 03:20:02 -0700, Joerg
wrote:

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

Can you be more specific with your instructions? I've tried a number of
different combinations and all that happens is a line return, which gives me
even less space in the cell. Thanks!


"Gord Dibben" wrote:

Add a linefeed every 100 characters.

100 charsAlt + Enter100 charsAlt + Enter.


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 03:20:02 -0700, Joerg
wrote:

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg

How can the number of words per cell in Excel be increased?
 

Format the cell to wrap text after you have added the linefeeds.


Gord

On Thu, 30 Apr 2009 07:27:01 -0700, Pamela
wrote:

Can you be more specific with your instructions? I've tried a number of
different combinations and all that happens is a line return, which gives me
even less space in the cell. Thanks!


"Gord Dibben" wrote:

Add a linefeed every 100 characters.

100 charsAlt + Enter100 charsAlt + Enter.


Gord Dibben MS Excel MVP

On Mon, 16 Mar 2009 03:20:02 -0700, Joerg
wrote:

Hi there!
I am working on an Excel spread sheet with a lot of text information. There
appears to be maximum number of words/characters set for each cell, so that
parts of the text information are not displayed. Regardless if I increase the
cell size.
Any feedback welcome.
Many thanks
Joerg