Function Problems

Display Multiple Lines in One Excel Cell with a Formula

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 869 views

Question details

Combine values from several cells into one Excel cell, with each value on a separate line.

Display Multiple Lines in One Excel Cell with a Formula
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants a formula to insert line breaks automatically instead of adding them manually.
Observed behavior
A single result cell displays each source value on its own line.
Before you start

Identify the cells you want to combine and choose an empty cell for the result. The example below uses cells A1 through D1.

Solution 1Recommended

Combine cell values with CHAR(10) and Wrap Text

Use a formula to insert line breaks between values and display them within one cell.

1
Enter the formula

Select an empty cell, enter =A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1, and press Enter. Replace the cell references with the ones you need.

2
Enable Wrap Text

Select the result cell, then go to Home > Wrap Text to show each value on a separate line.

3
Adjust the row height

If a line is hidden, double-click the bottom boundary of the row heading to fit the row to its contents.

Combine cell values with CHAR(10) and Wrap Text
Add or remove values: For each additional value, append &CHAR(10)& followed by its cell reference. Remove a reference and its adjacent line break if you need fewer values.
WPS Office

Create multiline cells in WPS Spreadsheet

Use the same CHAR(10) formula in WPS Spreadsheet and turn on Wrap Text to display combined values on separate lines.

  1. 1. Open your spreadsheet: Open WPS Spreadsheet and select File > Open to load your workbook.
  2. 2. Enter the formula: Select an empty cell, enter =A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1, and press Enter.
  3. 3. Wrap the result: Select the formula cell and click Wrap Text on the Home tab.
  4. 4. Fit the row: If needed, double-click the bottom boundary of the row heading to show all lines.
Combine cell values with formula-based line breaksOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceGet started with WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Why are the combined values still displayed on one line?

Select the result cell and click Home > Wrap Text. If some lines are still hidden, double-click the bottom boundary of the row heading to adjust the row height.

What does CHAR(10) do in the formula?

CHAR(10) inserts a line break between the values joined by the formula. Enable Wrap Text to display the values on separate lines within the cell.

Can I combine only two cells on separate lines?

Yes. Enter =A1&CHAR(10)&B1 in an empty cell, then select Home > Wrap Text.

Will the result change when a source cell changes?

Yes. Because the formula refers to the source cells, Excel updates the combined result when their values change.