#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.



Dhruba Bandopadhyay wrote:

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