Don't think that's the problem.

Don't remember how far in the distant past the display may have been
limited to 255 chars, but at least in XL97/98/00/01/02/v.X/03/04, the
limit is 1024.



In article ,
Leith Ross wrote:

In pre-2007 Excel versions, the limit a cell can display is 255
characters. The formula bar, however, can display up to 32K. All
characters are stored internally up to 32k. The Split function will
handle strings up to the maximum, so the problem isn't the Split
function. It merely how Excel is displaying the data.