Method 3 – Using the TEXTJOIN Function to Concatenate (for Excel 2019 and Office 365 only) So, it doesn’t really matter which of the two functions you use. However, in this case, we only need to reference the cells individually (since each string needs to be separated by a line break character). The only difference is that the CONCAT function lets you reference a range of cells instead of individual ones.

Both functions do more or less the same thing. You can also use the CONCAT function instead of CONCATENATE. To demonstrate all three methods, we will be using the following dataset: Now let us look at the three ways to use this CHAR function and concatenate with line breaks in Excel. 3 Ways to Concatenate with Line Breaks in Excel We will be using this function in all the formula methods of this tutorial to create a line break character. So to display a line break character in Excel, we use the formula =CHAR(10). The CHAR function takes just one parameter, which is the ASCII code that you want to convert to a symbol.

For example, the ASCII code for the line break character is 10. It is usually used to specify characters in Excel that are hard to enter into a formula.Īn ASCII value is an integer between 1 and 255, each one representing a specific character. The CHAR function in Excel returns the character that corresponds to an ASCII value. However, in Excel, we need to use a Unicode character, specified using the CHAR function.

In regular programming languages, the ‘ ’ character is used to represent line breaks.

Method 3 – Using the TEXTJOIN Function to Concatenate (for Excel 2019 and Office 365 only)īefore we show you how to combine text with line breaks, it is important to understand how line breaks are represented in Excel.

Method 2 – Using the CONCATENATE Function.

Method 1 – Using the Ampersand (&) Operator.

3 Ways to Concatenate with Line Breaks in Excel.

Concatenate in openoffice excel