I want to put two (or more) lines of text in the same cell. Like

Network
Command

Is there any way to do that?

Dick

If you're typing the value, use alt-enter to force a new line within the cell.

If you're using a formula, you can use:
=a1&char(10)&b1

(format the cells to have wrap text, too.)



Dick wrote:
>
> I want to put two (or more) lines of text in the same cell. Like
>
> Network
> Command
>
> Is there any way to do that?
>
> Dick

--

Dave Peterson

Easily!

Enter your first line of text, press <ALT>-<Enter> enter your second
line of text!


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546103

Thank you very much.

Dick

On Fri, 26 May 2006 20:46:30 -0500, Dave Peterson
<(E-Mail Removed)> wrote:

>If you're typing the value, use alt-enter to force a new line within the cell.
>
>If you're using a formula, you can use:
>=a1&char(10)&b1
>
>(format the cells to have wrap text, too.)
>
>
>
>Dick wrote:
>>
>> I want to put two (or more) lines of text in the same cell. Like
>>
>> Network
>> Command
>>
>> Is there any way to do that?
>>
>> Dick