View Single Post
  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

And if you ever want to create a formula that does this:

=a1&char(10)&a2

(but make sure format|cells|alignment tab|wrap text is checked)

!!!help!!! wrote:

I am using Excel 98 and want to know how to get 2 lines of text in 1 cell
rather than space it out over 2 cells. See below for example if you dont get
it.....

This is what (cell no.1)
I mean. (cell no. 2)

I want to be (cell no.1)
able to do this. (cell no.1)

Please help.....thanks


--

Dave Peterson