Excel Formula Line Break: How to Add One in a Cell

Formulas & functions · Updated November 18, 2026

To put a line break in an Excel formula, join the text with CHAR(10), then turn on Wrap Text for the cell. For example, if the two pieces of text are in A2 and B2, =A2&CHAR(10)&B2 puts the value from B2 on a new line below the value from A2.

What CHAR(10) does in an Excel formula

CHAR(10) returns the line-feed character, which Excel uses as an in-cell line break. It does not create a new worksheet row or insert a break between cells; it adds a line break inside the text produced by the formula. The ampersand joins the text on either side of that character, so the formula’s result contains both text and a line break.

For example, with a person’s name in A2 and job title in B2, the formula can combine the two values in one cell while keeping them on separate lines. This is useful for compact labels, address blocks, product descriptions, and other output that would be awkward in a single long line. The underlying values remain in their original cells; the formula cell displays a combined result.

The line break is part of the result even if it is not immediately visible. Excel’s Wrap Text setting controls whether the cell displays that result across multiple lines. This is why a formula can be correct while the cell appears to show one continuous line.

How to add a line break step by step

  1. Enter the text or values you want to combine in separate cells. In this example, put a name in A2 and a role in B2.
  2. Select the cell where you want the combined result, such as C2, and enter the formula below.
  3. Press Enter to calculate the formula.
  4. Select the result cell, then choose Home > Alignment > Wrap Text.
  5. If the full result is not visible, adjust the row height. You can drag the row boundary or choose Home > Format > AutoFit Row Height.

With the name Maya Chen in A2 and Analyst in B2, the result in C2 is Maya Chen on the first line and Analyst on the second. The formula uses the referenced cell contents, so changing either source value updates the result automatically. If you copy the formula down, Excel normally adjusts the row references for each new row.

Basic formula examples

With a first name in A2 and a last name in B2, enter this formula in C2. If A2 contains Maya and B2 contains Chen, the result is Maya on the first line and Chen on the next:

=A2&CHAR(10)&B2

To add labels, use a formula that joins fixed text with cell references. With a name in A2 and a department in B2, this formula returns Name: Maya on the first line and Department: Research on the second when those are the cell values:

="Name: "&A2&CHAR(10)&"Department: "&B2

For a three-line result, add another CHAR(10) between the next pair of pieces. With a product in A2, a category in B2, and a price in C2, the formula below puts each value on a separate line. If the cells contain Notebook, Stationery, and $4.50, the result has those three lines in that order:

=A2&CHAR(10)&B2&CHAR(10)&C2

These examples use the ampersand operator because it makes the order of the parts easy to see. You can combine cell references, fixed labels, and other text in the same way. If you want punctuation or spaces, include them in quoted text, taking care to keep each quote mark paired.

Adding a line break only when a condition is met

A line break can also be included only when a condition is true. For example, suppose A2 contains a product name, B2 contains an optional description, and C2 contains a status that is either Yes or No. The formula below adds a second line only when C2 is Yes. If A2 is Notebook, B2 is Recycled paper, and C2 is Yes, the result is Notebook followed by Recycled paper on a new line. If C2 is No, the result is just Notebook.

=A2&IF(C2="Yes",CHAR(10)&B2,"")

The empty text value in the last part of the IF function means “add nothing” when the condition is false. This pattern is helpful when some records have optional details and you do not want a blank second line for every record. If B2 can be empty even when C2 is Yes, you may want to test B2 as well, so the formula does not add a line break with no text after it.

Combining several cells with TEXTJOIN

When you want to combine a range of cells and place each entry on its own line, TEXTJOIN can be more convenient than repeating the ampersand and line-break character. It is available in Microsoft 365 and supported newer Excel versions. With entries in A2:A4, this formula joins them using a line break and ignores empty cells. If the cells contain Apples, a blank, and Pears, the result is Apples on the first line and Pears on the second:

=TEXTJOIN(CHAR(10),TRUE,A2:A4)

The first argument is the separator, here a line break. The second argument, TRUE, tells Excel to ignore empty cells. If you use FALSE instead, empty cells are included as empty positions, which can leave blank lines between visible entries. Check whether blanks should be skipped before choosing that setting. As with other formulas using CHAR(10), apply Wrap Text to display the result on multiple lines.

Wrap Text, row height, and what appears on screen

A line break in the formula result and automatic text wrapping are related but different. CHAR(10) puts a specific break at a specific point in the result. Wrap Text lets Excel display content across multiple lines when it does not fit the cell width, even if the formula contains no line-break character. You can use both together: the explicit break determines where a new line begins, while wrapping handles any additional text that is too long for the column.

After turning on Wrap Text, Excel often adjusts a row’s height to show the lines. If it does not, use Home > Format > AutoFit Row Height, or drag the row boundary to make the row taller. A narrow column can make a line wrap again, so widen the column if the result breaks in inconvenient places. Merged cells can also make automatic row sizing less predictable; manually setting the row height may be necessary.

Wrap Text is a display setting, not a change to the formula. Turning it off does not remove CHAR(10) from the result, and turning it back on can show the lines again. Likewise, changing a column width does not change the formula’s text, although it may change where Excel wraps that text visually.

Formula line breaks versus typing a manual break

If you are entering text directly rather than building it with a formula, use a manual line break inside the cell. In Excel for Microsoft 365 on Windows, edit the cell, place the insertion point where the next line should begin, and press Alt+Enter. On a Mac, the corresponding shortcut is Control+Option+Return. The exact key combination can depend on the keyboard and Excel environment, so use the in-cell editing cursor to confirm the break is being inserted in the cell rather than submitted elsewhere.

A manually entered break is part of the cell’s typed content. A formula-based break is generated when Excel calculates the formula, which is preferable when the text comes from other cells or needs to update as those values change. Neither method creates another worksheet row. Use a real row change when the information needs to be sorted, filtered, or calculated as separate records rather than merely displayed on separate lines.

Common problems and fixes

  • The result stays on one line. Select the formula cell and choose Home > Alignment > Wrap Text. Then increase the row height if needed. The line break may be present in the result even when the display setting hides its effect.
  • The formula shows an error. Check that the formula starts with an equals sign, that parentheses are balanced, and that quoted text has matching straight quotation marks. The formula examples here use commas as argument separators, as in a typical English-language Excel installation. Some regional settings use semicolons between function arguments; if Excel rejects a formula with commas, check the list separator used by your installation.
  • There is an unwanted blank line. Look for consecutive CHAR(10) characters, or a break added when an optional source cell is empty. Add a condition that checks whether the source has content before joining it.
  • Only part of the text is visible. Widen the column, use AutoFit Row Height, or increase the row height manually. Also check whether text in an adjacent cell or a fixed row height is affecting what can be seen.
  • The cell displays the formula instead of its result. Check whether the cell is formatted as Text. Change it to General, then re-enter the formula so Excel calculates it. Also check that Show Formulas has not been turned on for the worksheet.

When sharing a workbook, remember that the formula and its display settings are separate parts of the result. A recipient may see a long line if Wrap Text is off, even though the formula still contains the break. If the exact printed layout matters, check the cell width, row height, and print preview as well as the formula.

Excel for Mac and Excel for the web

The formula using CHAR(10) works in Excel for Microsoft 365 on Windows and in current Excel for Mac. The formula itself does not need a different character on Mac. The ribbon layout can differ slightly by platform, but the Wrap Text control is available from the Home tab. For a manually typed break, use the Mac shortcut described above rather than the Windows Alt+Enter shortcut.

Excel for the web also supports formulas and cell wrapping, though its menus and keyboard behavior can differ from the desktop app. If a keyboard shortcut does not behave as expected in a browser, use the ribbon’s Wrap Text control and edit the formula directly. In all versions, confirm the result in the target cell: the formula should calculate, and the cell needs enough visible height to show its lines.

Frequently Asked Questions

What formula inserts a line break in Excel?
Use CHAR(10) between the text pieces you want to join, such as a cell reference, the line-break character, and another reference. Turn on Wrap Text to display the lines inside the cell.

Why does CHAR(10) not work in my Excel cell?
The formula may contain the break but the cell may not be set to Wrap Text. Select the cell, choose Home > Alignment > Wrap Text, and adjust the row height if the full result is still hidden. Also check that the cell is not formatted as Text.

Is CHAR(10) the same as Wrap Text?
No. CHAR(10) inserts a line-feed character at a chosen point in the formula result. Wrap Text changes how Excel displays long content and can wrap it based on the cell width, without changing the formula’s text.

Can I put several line breaks in one formula?
Yes. Join each piece of text with another CHAR(10). Each one adds a break at that point, so three text pieces separated by two break characters produce three intended lines, subject to cell width and wrapping.

How do I add a line break without a formula?
Edit the cell and press Alt+Enter on Windows or Control+Option+Return on Mac at the point where the next line should start. This inserts a manual break in the cell’s text rather than building the text from formula references.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.