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)….

 

Related Posts
How to Select All Non-Blank Cells of a Range

In daily work, we may meet the cases that select all blank cells or non-blank cells of a range. You may know the way to select all blank cells as they are “blanks”. But for non-blank cells, they may contain ...

How to ignore Blank Cells while Concatenating cells in Excel
concatenate cell but blanks3

This post will guide you how to concatenate cells but ignore all blank cells in your worksheet in Excel. How do I concatenate cells but ignore blank cells with a formula in Excel. How to create a concatenate formula to ...

How To Concatenate Cells If Same Value Exists in Another Column in Excel
Concatenate Cells If Same Value Exists in Another Column15

This post will guide you how to concatenate cells if same value in another column using an VBA macro in Excel. How do I merge cells if same value exists in another column using formula and filter feature in Excel ...

How to Delete or Remove Year from a Date in Excel
delete year from date2

This post will guide you how to delete or remove year from a given standard date in Excel. How do I remove the year from a date with a formula in Excel. Remove Year from a Date Assuming that you ...

How to Concatenate Data with a Line Break in Excel
concatenate cells with line break3

This post will guide you how to combine multiple cells with line break in Excel. How do I concatenate cells with a line break character into one cell with formula in Excel. Concatenate Data with Line Break Character You can ...

How to Concatenate Cells and keeping Date Format in Excel
concatenate cells and keep date format1

This post will guide you how to concatenate cells and keeping data format in Excel. How do I concatenate cells and retain the certain Date format with a formula in Excel 2010/2013/2016. Concatenate Cells and Keeping Date Format Assuming that ...

How to Find and Highlight Duplicate Rows in Excel
find duplicate rows6

This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two ...

Combing the First and Last Names
combing first and last names2

This post will guide you how to quickly combine the first and the last names into one single cell in an Excel Worksheet. How do I combine first and last name columns in Excel. Combing the First and Last Names ...

How to Add Prefix or suffix to Cell
add prefix to cell113

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Highlight Duplicate Rows
highlight duplicate rows16

This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a ...

Sidebar