HELP: text keeps on displaying ##############

[Dhruba Bandopadhyay]

1. What is the maximum characters an Excel cell can take?

I try to import a very large text string into an Excel cell. I notice that
it's truncated to a certain maximum length.

When I set the cell type to be TEXT it displays #########################
But when I set cell type to GENERAL then it displays ok.

Is this a normal common problem?

I just did a Len() on my text cell and it appears the maximum characters
allowed is 330. Is it possible to extend this?

 

[Dave Peterson]

#1. In xl97+, it's 32,767 characters per cell. Excel's help says you can see
1024 characters, but you can see more if you add alt-enters (to force new lines
within the cell) every 80-100 characters.

Change the format back to General--anything but Text and you'll see the text.
Excel has trouble showing long text (between 255 and 1024 characters) when the
cell is formatted as Text.

 

[Guest]

I'm in Excel 2003 - the limit in a cell appears to be 32,767 characters and
I'm getting none of the Text v. General formatting problems you mention. I
have come across this kind of restriction when importing from Access as it
assumes the old Excel limit of 256 and (unnecessarily for Excel 2000 and
2003) truncates everything after that.