If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it http://support.microsoft.com/default.aspx?scid=kb;en-us;281517...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2009/06/22/5781.aspx