Combine values from different cells with line break

This tutorial shows how to concatenate values from different cells into one cell separated by line breaks for each combined value using Excel formulas, with the CONCATENATE function and & sign

Excel

Combine values from different cells with line break using CONCATENATE function

Excel

Combine values from different cells with line break using & sign

EXCEL FORMULA 1. Combine values from different cells with line break using CONCATENATE function

EXCEL

Combine values from different cells with line break

=CONCATENATE(B5,CHAR(10),B6,CHAR(10),B7,CHAR(10),B8)

GENERIC FORMULA

=CONCATENATE(value1,CHAR(10),value2,CHAR(10),...)

ARGUMENTS
value1: The first value that you want to concatenate.
value2: The second value that you want to concatenate.

EXPLANATION

This formula uses the CONCATENATE function with the value that you want to combine including CHAR(10) between each of the values separated by a comma. CHAR(10) is used to return a line break character.

Please note that the results cell has a wrap text format applied to it.

In this example the formula combines the values captured in cells B5 to B8 in the same order that they have been selected in the formula and creates a line break between each of the selected values.

EXCEL FORMULA 2. Combine values from different cells with line break using & sign

EXCEL

Combine values from different cells with line break

=B5&CHAR(10)&B6&CHAR(10)&B7&CHAR(10)&B8

GENERIC FORMULA

=value1&CHAR(10)&value2&CHAR(10)&...

ARGUMENTS
value1: The first value that you want to concatenate.
value2: The second value that you want to concatenate.

EXPLANATION

This formula uses the & sign to combine the values from different cells including CHAR(10) between each of the values separated by a comma. CHAR(10) is used to return a line break character.

Please note that the results cell has a wrap text format applied to it.

In this example the formula combines the values captured in cells B5 to B8 in the same order that they have been selected in the formula and creates a line break between each of the selected values.

Related Topic	Description	Related Topic and Description
Combine value in cells with a comma	How to combine values in separate cells with a comma (,)
Combine values from different cells	How to concatenate values from different cells into one cell
Combine values from different cells with a space	How to concatenate values from different cells into one cell separated by a single space