Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to concatenate text with a line break in Excel and Google Sheets
Excel & Google Sheets
=A2 & CHAR(10) & B2✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| First Name | Last Name |
| John | Doe |
| Jane | Smith |
| Alice | Johnson |
=A2 & CHAR(10) & B2→John
Doe
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your text in separate cells (e.g., A2 and B2).
- 2In another cell, use the formula provided to concatenate the text from these cells with a line break.
- 3Press Enter to see the concatenated text with a line break.
Tips
- Ensure the cell containing the formula has 'Wrap text' enabled to display line breaks properly.
- In some locales, you might need to use CHAR(13)&CHAR(10) instead of CHAR(10) for line breaks in Excel.
- If you're using Google Sheets, CHAR(10) works universally for line breaks.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Why isn't the line break showing up?
Make sure the cell formatting includes 'Wrap text'. Without this, line breaks won't be visible.
Can I use this method in other functions like CONCATENATE?
Yes, you can use CHAR(10) within the CONCATENATE function as well.
What if I want to add more than one line break?
Simply add multiple CHAR(10) in your formula where needed, e.g., A2 & CHAR(10) & CHAR(10) & B2 for two line breaks.