In a spreadsheet, I have a CELL (not the formula bar) that is displaying over
1550 characters, how is this possible?. Other cells limit character count
per the 1024 limit. If I copy the contents of this errant sell to another
part of the spreadsheet, the contents get spread over a number of rows (in
the same column).
As part of the puzzle, I can't see how to verify how many characters are in
a cell whilst performing free-form text entry into a cell (other than to use
the 'Mid' function and test when it hits a pre-defined limit), not do I see
how this errant cell came to be created. There is a word count function but
no character count function that I can find.
There are other cells in the same column that exhibit this anomaly, others
that don't. I have tried merging cells to get the effect but did not manage
to replicate it. The errant cells have a single identity e.g. D3, they are
not a range of cells, nor is the content of the cell the result of a
concatenation of data elsewhere on the spreadsheet (CONCATENATE or use of '&'
to 'glue' text together).