PC Review


Reply
Thread Tools Rate Thread

How Can You Put Two Lines of Text in Same Cell?

 
 
Dick
Guest
Posts: n/a
 
      27th May 2006
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      27th May 2006
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
 
Reply With Quote
 
bgeier
Guest
Posts: n/a
 
      27th May 2006

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

 
Reply With Quote
 
Dick
Guest
Posts: n/a
 
      27th May 2006
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Text lines in a cell =?Utf-8?B?Um93YW4=?= Microsoft Excel Misc 0 31st Aug 2005 08:26 AM
Re: Text lines in a cell Ed Ferrero Microsoft Excel Misc 0 31st Aug 2005 08:23 AM
Re: Text lines in a cell Paul Sheppard Microsoft Excel Misc 0 31st Aug 2005 08:07 AM
Two Text Lines in one Cell. =?Utf-8?B?UGV0ZXI=?= Microsoft Excel Misc 2 11th Apr 2004 04:59 PM
text lines in a cell John Microsoft Excel Misc 1 19th Mar 2004 09:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:01 PM.