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.

"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?