On Oct 31, 12:52 pm, "Niek Otten" wrote:
Hi John,
There is no published limit. I suppose that, like many other "limits" one could think of, it depends on how you create them
(formulas? Import? manual entering?) and available memory.
But I downloaded a workbook containing the complete King James' Bible:http://j-walkblog.com/index.php?/web...ible_in_excel/

You might want to try and explain what you're trying to achieve and what behavior of Excel
won't let you


Hi,

There isn't any real world application for this. I was just curious if
this is a known limit. It isn't mentioned is the usual "Excel
specifications and limits".

BTW, that copy of the King James Bible has only 62,018 unique
strings. :-)

John.
--