Concatenate with line break in Excel

For example, I would like to combine values in Columns G, H and I separated by line breaks in Column J as shown below. As I have a very big table, doing it manually is very laborious.

excel concatenate with line break

To do it in Excel, here is the answer:

a) Enter the formula =G4 & CHAR(10) & H4 & CHAR(10) & I4 in cell J4 as shown below. Drag the formula all the way down to end of the column.

ASCII code for line break is 10. Hence CHAR(10) is used in formula.

excel concatenate with line break

b) All the cells in "Combined Attributes" column have data in desired format.

Note: Select the cells in column and click on "Wrap Text" under "Home" to display as shown in Screenshot. If Wrap Text is not set, the cell values would show up next to each other.

excel concatenate with line break


You can find similar Excel Questions and Answer hereunder

1) Line break in vba message box in Excel

2) How to concatenate strings in vba in Excel

3) Here some explanations about xml and how to use xml in VBA

4) What are the addins in the developer tab in Excel

5) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

6) How can I activate a routine when there is a change in value of a cell?

7) Concatenate number with text but keeping in number format in Excel

8) How can I avoid updates to cell values during macro execution?

9) I want to force a page break at a certain row - how can I do that?

10) How can I filter and copy only filtered data using VBA?


Here the previous and next chapter