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

  • Thread starter Thread starter Dick
  • Start date Start date
D

Dick

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.)
 
Easily!

Enter your first line of text, press <ALT>-<Enter> enter your second
line of text!
 
Thank you very much.

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top