In Excel, how do I put multiple rows of text in one cell.
 

In other words, I need to be able to set a paragraph in one text box, but
cannot display it as one really long line. I need it to be multiple lines of
text in one cell in other words. I have seen it done before.

In Excel, how do I put multiple rows of text in one cell.
 

Separate the line with Alt-Enter.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"cbeatty551" wrote in message
...
In other words, I need to be able to set a paragraph in one text box, but
cannot display it as one really long line. I need it to be multiple lines
of
text in one cell in other words. I have seen it done before.

In Excel, how do I put multiple rows of text in one cell.
 

Just press Alt+ENTER to break for a new line
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"cbeatty551" wrote:
In other words, I need to be able to set a paragraph in one text box, but
cannot display it as one really long line. I need it to be multiple lines of
text in one cell in other words. I have seen it done before.

In Excel, how do I put multiple rows of text in one cell.
 

make sure you format the cell for wrapping text
formatcellalignment

Note if there are too many characters, excell will not format the excess (I
think it is 256 but wont swear to it) and you will not be able to use text
wrapping further in that Cell.
a way to get around it is to put the information in a comment. I personally
do not know of a limit for the formatting in a comment.

"cbeatty551" wrote:

In other words, I need to be able to set a paragraph in one text box, but
cannot display it as one really long line. I need it to be multiple lines of
text in one cell in other words. I have seen it done before.