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
|