How do I insert a line break when using the CONCATENATE function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to combine text into a single cell but I want the text to be stacked
vertically not in a line.
 
Use char(10).

Example:

=CONCATENATE("How",CHAR(10),"now,",CHAR(10),"brown cow?")

Good luck,

Tom Hayakawa
 
Shane

=A1 & CHAR(10) & A2 & CHAR(10) & A3......on and on

Format to "wrap text"

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Concatentate text and insert blank line 2
Constructing Range Name calls with Concatenate 4
How specify number format of cell value in concatenate function? 1
Creating a list / concatenate function 5
How do I insert a line break using a formula (e.g when concatenat. 2
Problem with Concatenate - Results are too long for CSV 4
Merge contents of cells and insert line space 3

Back
Top