Concatenate columns with Line Breaks (Alt + Enter)

This post will guide you how to combine multiple cells in one or more columns into one cell with line breaks or Alt +enter in Excel. How do I concatenate different values together into one cell with line breaks.

For example, if you are trying to combine three cells (B1,B2,B3) into one(C1) with line breaks or Alt + Enter separating each value. You can refer to the below tutorial to achieve the result.

Concatenate columns with Line Breaks (Alt + Enter)

To concatenate the cells with line breaks, you should use the concatenate operator in combination with the CHAR(10) or CHAR(13) function. It means that if you want to add line breaks, you need to use the CHAR(10) to insert actual line breaks on Windows or use the CHAR(13) to insert line breaks on MAC system.

To join the cells with line breaks, just do the following steps:

#1 type the following formula into the Cell C1, then press Enter key.

=B1& CHAR(10) & B2 &CHAR(10)&B3

concatenate columns with line break2

or you can also use the CONCATENATE function as below:

=CONCATENATE(B1&CHAR(10),B2&CHAR(13),B3)

concatenate columns with line break11

2# Select the Cell C1, then go to Home Tab, click Warp Text command under Alignment group.

3# you will see that three cells in column have been concatenated with line breaks or Alt +Enter.

concatenate columns with line break1


Related Functions

  • Excel Concat function
    The excel CONCAT function combines 2 or more strings or ranges together.This is a new function in Excel 2016 and it replaces the CONCATENATE function.The syntax of the CONCAT function is as below:=CONCAT (text1,[text2],…)…
  • Excel CHAR function
    The Excel CHAR function returns the character specified by a number (ASCII Value).The CHAR function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The syntax of the CHAR function is as below:=CHAR(number)….

 

Leave a Reply