Thursday, September 24, 2009

More on Excel Cell Size Limitation

Excel 2003 can store up to 1024 characters in a cell. However, is shows only the first 256 characters so one may think the rest has been lost. If you look at the top input area you can see the entire string but not in the cell itself or upon printing. Excel 2007 doesn't have this issue and can correctly handle veryyyyyy long strings.

When you copy to other programs the target cell may have the same limitation and will cut the string, as explained in a previous article pertaining SharePoint Link type column.

No comments:

Post a Comment

Enter your comment here