After you clear advice, we suggest to enlist assistance of len function,
inserting breaks once it exceed a set number of characters. Certainly need
adjustment to len of the cell immediately following the blank line please.

"Bryan Hessey"
wrote in message
news:Bryan.Hessey.1ydsja_1131794401.6728@excelforu m-nospam.com...

Also, the 1024 is limited by 255 character column width, and 409 points
of row height (about 550 pixels).
The only way I know to view all text in a 'full' cell is via 31
following helper rows which use =mid(a1,1024,1024) where the mid figure
increments by 1024 =mid(a1,2048,1024) etc until 31744 or no further
data, but I don't think this is a wise use of Excel and the text would
be more appropriately located in MS Word.

Screen shots of the formula bar (press the PrtSc or PrintScreen button)
pasted via Ctrl/V into MS Word, trimmed via the Crop tool, and adjusted
to readable size are time comsuming to say the least, but how else does
one get a hard copy.

Cheers.


PY & Associates Wrote:
We knew about 1,024 but didn't border to dig up 32,767.
Thank you for your advice.

"Bryan Hessey"

wrote in message
news:Bryan.Hessey.1ydq7z_1131791401.8066@excelforu m-nospam.com...

In the help, search for Limit and look up
Excel specifications and limits
Worksheet and workbook specifications
which includes:

Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


PY & Associates Wrote:
Sorry, I looked at your post again and admit I have missed D1 as in

=D1&","&A2&","&B2&","&C2

My suggestion is therefore redundant.

For my curiosity, where is the 32,767 characters come from please?

"Bryan Hessey"

wrote in message
news:Bryan.Hessey.1ydc3m_1131773100.8989@excelforu m-nospam.com...

OK - I guess that beats me, as
E1 will then = A1,B1,C1
E2 will then = A1,B1,C1A1,B1,C1,A2,B2,C2
E3 will then =
A1,B1,C1A1,B1,C1,A2,B2,C2A1,B1,C1,A2,B2,C2,A3,B3,C 3
E4 will then =



A1,B1,C1A1,B1,C1,A2,B2,C2A1,B1,C1,A2,B2,C2,A3,B3,C 3A1,B1,C1,A2,B2,C2,A3,B3,C[color=blue]
3,A4,B4,C4


and the progression gets increasingly further from what the OP
requested.
It is (almost) possible to visually inspect, but of 32,767
characters
only 1024 are displayed in the row, the full set is displayed
only
in
the formula bar.

A better suggestion for checking might be that E1 be

=Right(D1,40)

and formula copy that to the end of data rows, at the point of
overflow the E column ceases changing and displays the same
characters
32,728 to 32,767


--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=484382



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=484382