T
TKT-Tang
Re - Excel AutoFit and Long Text Strings
1. There is a requirement to enter long text strings into a column of
cells respectively.
2. Say, the column may be 50-wide and each cell is to accommodate 2000
characters, more or less.
3. Autofit the long-text cell could no longer display the entire
character string thereof.
4. The question is, by seeking circumvention, whether there are other
ready built-in formulae which may be applied to evaluate the number of
lines in the long-text cell such that the cell height can be aptly
adjusted thereinafter (in order to accommodate the display of the
character string in entirety).
5. Neutrally speaking, the tedium of dragging the lower border of the
long-text cell (to suit a situation) is so much an odium. Needless to
say, Autofit is striving well mostly to conjure presto (albeit falling
short of expectation in this instance) ; being relentlessly pursuant
of Exellence (there yields no coincidence that Excel should bear the
namesake), the spreadsheet should be distinctively manifest of an
abhorrence against trials-and-tribulations.
6. Please enlighten upon the given results as observed.
7. Regards.
1. There is a requirement to enter long text strings into a column of
cells respectively.
2. Say, the column may be 50-wide and each cell is to accommodate 2000
characters, more or less.
3. Autofit the long-text cell could no longer display the entire
character string thereof.
4. The question is, by seeking circumvention, whether there are other
ready built-in formulae which may be applied to evaluate the number of
lines in the long-text cell such that the cell height can be aptly
adjusted thereinafter (in order to accommodate the display of the
character string in entirety).
5. Neutrally speaking, the tedium of dragging the lower border of the
long-text cell (to suit a situation) is so much an odium. Needless to
say, Autofit is striving well mostly to conjure presto (albeit falling
short of expectation in this instance) ; being relentlessly pursuant
of Exellence (there yields no coincidence that Excel should bear the
namesake), the spreadsheet should be distinctively manifest of an
abhorrence against trials-and-tribulations.
6. Please enlighten upon the given results as observed.
7. Regards.