# How to add a line break in a formula in Excel

Join CHAR(10) between the parts: =A2&CHAR(10)&B2&CHAR(10)&C2, then turn on Wrap Text for the cell.

**Excel:** `=A2&CHAR(10)&B2&CHAR(10)&C2` (Excel 2019 and later, including Microsoft 365)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Company | Street | City | Mailing label |
| Northwind Traders | 1420 Lake St | Minneapolis, MN 55401 |  |
| Contoso Ltd | 88 Oak Ave | Saint Paul, MN 55102 |  |
| Fabrikam Inc | 7 Elm Ct | Madison, WI 53703 |  |
| Litware | 305 River Rd | Fargo, ND 58102 |  |
| Adatum Corp | 12 Pine Ln | Duluth, MN 55802 |  |

Formula in D2, filled to D6: `=A2&CHAR(10)&B2&CHAR(10)&C2`

Result: Northwind Traders
1420 Lake St
Minneapolis, MN 55401; Contoso Ltd
88 Oak Ave
Saint Paul, MN 55102; Fabrikam Inc
7 Elm Ct
Madison, WI 53703; Litware
305 River Rd
Fargo, ND 58102; Adatum Corp
12 Pine Ln
Duluth, MN 55802

## How it works

CHAR(10) is the line feed character, the same one Alt+Enter types. Joined between the parts, it starts a new line inside the cell. The cell has to have Wrap Text on to show the lines; otherwise they appear run together.

## Other ways

- `=TEXTJOIN(CHAR(10),TRUE,A2:C2)`: TEXTJOIN uses the line break as its separator and skips empty parts, so a missing street doesn't leave a blank line.

## Common mistakes

- Without Wrap Text the cell looks like "Northwind Traders1420 Lake St…". Turn it on in Home > Wrap Text.
- Typing "\n" in quotes doesn't work; spreadsheets need CHAR(10).

## Questions

**Does CHAR(10) work in Google Sheets?**

Yes. The same formula works, and Google Sheets wraps the lines when text wrapping is on.

**How do I remove the line breaks again?**

Replace them with a space: `=SUBSTITUTE(D2,CHAR(10)," ")`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/add-a-line-break-in-a-formula