I put
=rept("x",32765)&"y"
in A1:A5
and converted to values (edit|copy, edit|pastespecial|values)

And then I did edit|find to search for y's. It found those y's at the end of
those strings.

On the other hand, I've used Edit|Replace in long strings and gotten "Formula
too long" error messages returned--but never with edit|find.

But I'm not sure what a keyword search is for your application.

You may want to do some testing.


wrote:

I am creating an ASP.NET page to dump data to an excel file. This
works fine, but when I open the excel file I get an error that says
'the cell data is too large'. I heard from somebody that excel cells
can hold up to 32,000 character, but can only display 1,024 characters
in the formula bar. What restrictions does this impose on the data
that cannot be displayed? If I do a keyword search, is that data
still going to get searched?

Thanks in advance,

Ryan

--

Dave Peterson