Display Multiple Lines in One Excel Cell with a Formula
Question details
Combine values from several cells into one Excel cell, with each value on a separate line.

- 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.
Identify the cells you want to combine and choose an empty cell for the result. The example below uses cells A1 through D1.
Combine cell values with CHAR(10) and Wrap Text
Use a formula to insert line breaks between values and display them within one cell.
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.
Select the result cell, then go to Home > Wrap Text to show each value on a separate line.
If a line is hidden, double-click the bottom boundary of the row heading to fit the row to its contents.

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. Open your spreadsheet: Open WPS Spreadsheet and select File > Open to load your workbook.
- 2. Enter the formula: Select an empty cell, enter =A1&CHAR(10)&B1&CHAR(10)&C1&CHAR(10)&D1, and press Enter.
- 3. Wrap the result: Select the formula cell and click Wrap Text on the Home tab.
- 4. Fit the row: If needed, double-click the bottom boundary of the row heading to show all lines.

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.




