>Jim --
>
> I haven't encountered this problem, but here's something to try.
>
> Test the string to see if it's longer than 255. If so, put in a loop and assign only 254 characters at a time to the cell. Perhaps that would emulate the manual insertion of characters.
>
Interesting idea! I solved this a bit differently. I read in the Excel issues on technet, and found that if the cell contents is the result of some type of function, the problem does not appear. I placed the memo data in another, hidden, column, and set the intended column to =CLEAR(X#) of the hidden column, and it worked great. A bit of a weird solution, I admit. :)
Jim Newsom
IT Director, ICG Inc.