Maximun Text Caharacters in a Cell

  • Thread starter Thread starter EricS
  • Start date Start date
E

EricS

Does anyone know a way to get around thge maximun text characters in
cell that excel displays and print
 
Hi EricS

From Excel Specifications

32,767 characters. Only 1,024 display in a cell; all 32,767 display in
the formula bar.

If you exceed 1024 (which varies according to characters used) you
could use Data > Text to Columns

Before doing that, put in a symbol that's not used in the text at
convenient intervals (e.g. { ) and use that as the delimeter.

Once you have chunks in columns you can transpose to a vertical set of
text.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Does anyone know a way to get around thge maximun text characters in a
cell that excel displays and prints
Click to expand...

Manually add newline characters at regular intervals within the text by pressing
[Alt]+[Enter] with the cursor in those locations. If you use enough of these and
your zoom percentage and font's typesize are small enough and your row height
and column width large enough, you *can* display all 32767 chars that Excel can
hold in a cell.

One catch: there's no chance you'd be able to read any of them. 80 rows of 200
characters each is straining the limits of readability on most monitors, and
that's just 16,000 characters in total.
 
Back
Top