How to Add a Line Break in an Excel Formula

Join text with CHAR(10) to put each part on its own line — build multi-line mailing labels that skip empty address lines.

You will learn to

• Insert a line break in a formula with CHAR(10)
• Build a multi-line address block
• Skip blank lines with TEXTJOIN and CHAR(10)

How it works

Typing Alt+Enter adds a line break while you edit a cell, but inside a formula you need the character itself: CHAR(10), the line feed. =A2&CHAR(10)&B2 puts A2 on the first line and B2 on the second. Turn on Home › Wrap Text for the cell, otherwise Excel shows everything on one line.

For address blocks where some lines may be empty (no company, no suite number), use TEXTJOIN with CHAR(10) as the delimiter and TRUE to ignore blanks: =TEXTJOIN(CHAR(10),TRUE,A2:E2). On a Mac the same formula works — CHAR(10) is the line break there too in current Excel versions.

=A2&CHAR(10)&B2