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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
