Excel concatenate new line

In Excel, you can concatenate a new line using the & operator and the CHAR(10) function. Here are a few ways to do it:

Method 1: Using & and CHAR(10)

= A1 & CHAR(10) & B1

This will concatenate the values in cells A1 and B1 with a new line character (CHAR(10)) in between.

Method 2: Using & and vbCrLf

= A1 & vbCrLf & B1

This will also concatenate the values in cells A1 and B1 with a new line character (vbCrLf) in between. Note that vbCrLf is a VBScript constant that represents a carriage return and line feed.

Method 3: Using & and LINEFEED

= A1 & LINEFEED & B1

This will concatenate the values in cells A1 and B1 with a new line character (LINEFEED) in between. Note that LINEFEED is a constant that represents a line feed character.

Tips:

• You can also use the & operator with other text functions, such as TEXTJOIN, to concatenate multiple values with new lines in between.
• If you want to concatenate multiple values with new lines in between, you can use an array formula, such as =TEXTJOIN(A1:A10,CHAR(10)).
• You can also use the LINEBREAK function in Excel 2013 and later versions to concatenate new lines.