concatenate with line break in Excel
Q53. I want a formula to concatenate multiple cell values separated by line breaks.
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.
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.
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.