C
Chris.Coops
I've seen a couple of messages related to this, but the issue I have
seems to conflict with what is supposed to be the technical limits of
Microsoft Excel
I am using Microsoft Excel and have a column of single cells with text
data. In most rows, this cell has less than 255 characters, however,
in a few cells I have a lot more characters.
Most of the cells with more than 255 actually have between 256 and
1024 characters. All these cells seem to only show hashes in the
worksheet view, although the full text entry is present in the formula
bar above the worksheet.
However, I also have a couple of cells which have over 1025
characters, which display perfectly fine.
So to sum up, cells with 0 - 255 characters display perfectly fine in
the worksheet view.
Cells with 256 - 1024 characters display 255 hashes.
Cells with 1025 and more characters (so far I've tested with over
2000) display perfectly fine.
I've read the display limit is 255, so if that's the case why does
over 1024 display normally as well?
Can anyone give me the definitive specifications and if it contradicts
the information I have above, why?
Thanks
Chris
seems to conflict with what is supposed to be the technical limits of
Microsoft Excel
I am using Microsoft Excel and have a column of single cells with text
data. In most rows, this cell has less than 255 characters, however,
in a few cells I have a lot more characters.
Most of the cells with more than 255 actually have between 256 and
1024 characters. All these cells seem to only show hashes in the
worksheet view, although the full text entry is present in the formula
bar above the worksheet.
However, I also have a couple of cells which have over 1025
characters, which display perfectly fine.
So to sum up, cells with 0 - 255 characters display perfectly fine in
the worksheet view.
Cells with 256 - 1024 characters display 255 hashes.
Cells with 1025 and more characters (so far I've tested with over
2000) display perfectly fine.
I've read the display limit is 255, so if that's the case why does
over 1024 display normally as well?
Can anyone give me the definitive specifications and if it contradicts
the information I have above, why?
Thanks
Chris