Excel Text Join With Line Breaks: Formulas and Tips

Formulas & functions · Updated November 18, 2026

To join text with a line break in Excel for Microsoft 365, use TEXTJOIN with CHAR(10) as the delimiter. With values in A2:A5, enter =TEXTJOIN(CHAR(10),TRUE,A2:A5) in the result cell, then turn on Wrap Text so each joined item appears on its own line.

The formula and what it does

TEXTJOIN combines text from multiple cells and places a delimiter between the included values. In this case, the delimiter is CHAR(10), Excel’s line-feed character. Rather than inserting a comma or space, Excel starts a new line between entries. The second argument, TRUE, tells the function to skip empty cells.

For example, suppose A2 contains “North,” A3 is empty, A4 contains “Central,” and A5 contains “South.” With that layout, =TEXTJOIN(CHAR(10),TRUE,A2:A5) returns three lines: North, Central, and South. The empty A3 does not create a blank line because the formula is set to ignore empty values.

The line breaks are part of the value in the result cell; they are not separate rows or cells. You can copy the result, refer to it in another formula, or use it in a report, but the cell remains a single cell containing multiple lines of text.

Make the line breaks visible

A formula can contain line-feed characters while the cell still appears as one long line or seems to cut off the text. This is usually a display setting, not a formula error. Select the result cell and choose Home > Wrap Text. Excel will display the text on multiple lines within the cell, adjusting the row height as needed.

If the row does not expand to show every line, try AutoFit Row Height. Select the row, then choose Home > Format > AutoFit Row Height. You can also drag the row boundary to set a height yourself. A fixed row height may hide some lines, even though the full joined value is still present in the cell.

  • Windows: Select the result cell and use Home > Wrap Text.
  • Mac: Select the cell and choose Home > Wrap Text; the command is on the Home tab in Excel for Mac as well.
  • Excel for the web: Select the cell and use Home > Wrap Text. If the content still looks clipped, adjust the row height.

Column width affects where the text wraps naturally, but it does not replace the line breaks in the formula. Wrap Text is the setting that lets Excel display the embedded breaks as separate lines inside the cell.

Build the formula step by step

  1. Put the text items in a continuous range, such as A2:A5. The cells can include empty entries.
  2. Select the cell where you want the combined result to appear. Do not put the formula inside the source range, or the formula may refer to itself.
  3. Enter the formula, using the range that contains your own data. For values in A2:A5, use =TEXTJOIN(CHAR(10),TRUE,A2:A5).
  4. Press Enter, then enable Wrap Text for the result cell.
  5. Check the order and spelling of the source entries. The output follows the order of the cells in the range, from top to bottom.

TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. If you open a workbook in an older Excel version that does not support the function, the formula may show as an unrecognized-name error. For a fixed, short list of cells, a concatenation formula can be used instead, as described below.

Choose whether to skip empty cells

The TRUE or FALSE argument determines how blank entries affect the output. Use TRUE when blank cells should be omitted, which is common for lists with optional fields or incomplete records. Use FALSE when each position matters and you want Excel to retain the delimiter for empty cells. This can create adjacent line breaks and therefore a visually blank line.

With names in A2:A5, including a blank cell at A3, the formula =TEXTJOIN(CHAR(10),FALSE,A2:A5) retains the empty position. The returned text has a line break between the value in A2 and the blank A3 position, and another between that position and A4. If the blank does not need to be represented, use TRUE instead.

One nuance is that cells containing formulas that return an empty string can look blank. In typical list-building situations, the ignore-empty setting is useful for omitting empty text as well as truly empty cells. If you need a particular placeholder for missing data, put that placeholder into the source data or build an explicit rule for it; simply turning off ignore-empty does not insert words such as “Missing.”

Use a different range or a fixed list

For a longer list, change the range to include all the source cells. With items in B2:B100, the formula is =TEXTJOIN(CHAR(10),TRUE,B2:B100). You can also combine cells from separate ranges by supplying each range as an additional text argument. For example, with values in A2:A3 and C2:C3, use =TEXTJOIN(CHAR(10),TRUE,A2:A3,C2:C3). Excel joins the first range and then the second, keeping the order in which the arguments appear.

If there are only two or three fixed cells, the ampersand operator is another option. With text in A2 and A3, use =A2&CHAR(10)&A3. This returns the contents of A2, a line break, and the contents of A3. It is straightforward for a small, fixed number of cells, but it does not automatically skip blank entries. For a changing range or many cells, TEXTJOIN is generally easier to maintain.

When referencing entire columns, consider whether the range is larger than necessary. A formula such as =TEXTJOIN(CHAR(10),TRUE,A:A) may include far more cells than the actual list and can produce an unwieldy result if the column contains other content. A bounded range or an Excel Table column is usually clearer and makes the intended source data easier to identify.

Common problems and how to fix them

  • The result looks like one line: Select the result cell and turn on Wrap Text. Also check that the row height is not fixed too small.
  • The formula shows an error name: Confirm that the Excel version supports TEXTJOIN and that the function name and parentheses are entered correctly.
  • There are unexpected blank lines: Check for empty source cells and decide whether the second argument should be TRUE or FALSE. With FALSE, empty positions can leave consecutive line breaks.
  • The result is in the wrong order: TEXTJOIN follows the order of the range or arguments. Rearrange the source cells or change the range references.
  • Only part of the result is visible: Increase the row height, widen the column, or inspect the cell in the formula bar. Excel limits a cell’s text to 32,767 characters, so a very large joined result can exceed the cell limit.

Also check whether the formula was entered as text. If the cell displays the formula characters instead of a result, the cell may be formatted as Text, or the entry may begin with an apostrophe. Change the cell format to General, then re-enter the formula. Changing the format alone may not recalculate an entry already stored as text.

Line breaks can be hard to spot when editing the cell directly. The formula bar is useful for checking the formula itself, while Wrap Text and row height control the worksheet display. If you copy the result into another program, that program’s handling of line-feed characters may differ; the value is still one Excel cell, not a set of separate records.

How TEXTJOIN compares with other approaches

Manual line breaks are useful for a one-off value, while formulas are better when the source data may change. To insert a break while typing or editing a cell on Windows, press Alt+Enter at the point where the next line should begin. On Mac, the in-cell line-break shortcut is Control+Option+Return. This creates a fixed break in the cell’s contents; it does not dynamically combine other cells.

Using & with CHAR(10) gives direct control over a small set of cells, but each cell reference and separator must be typed. TEXTJOIN is more convenient for a range, offers the ignore-empty choice, and can accept multiple ranges or individual text arguments. A comma or space can be used as the TEXTJOIN delimiter instead when the goal is a paragraph or a comma-separated list rather than multiple lines.

Do not confuse a line break with a new worksheet row. CHAR(10) changes how text is separated inside the returned cell; it does not split the result into multiple cells. If the goal is one item per row, keep or transform the data into separate rows rather than joining it into one cell.

Practical considerations for shared workbooks

A line-break formula is useful for compact summaries, mailing labels, notes, or a multi-line address assembled from separate fields. For example, a single cell could show a person’s name, street, and city on separate lines. Before sharing the workbook, check that Wrap Text is enabled and that the row height makes all the lines visible. The formula and the visual formatting are separate, so another user can have the right value but a clipped display if the formatting is changed.

Be mindful of what is being combined. If the source cells contain identifiers, dates, or other values with formatting, TEXTJOIN uses their underlying text representation in the formula result; it does not necessarily preserve every source cell’s visual number format. For example, a date may appear as its serial number rather than in the date style shown in the source cell. If a specific display format matters, format that value as text deliberately before joining it, or use a suitable text-conversion step.

Finally, a combined cell is convenient for reading but less useful for sorting, filtering, or analyzing each item independently. Keep the original values in separate cells and treat the joined result as a display or export field. That preserves the structured data for later calculations and lets you rebuild the formatted text if an entry changes.

Frequently Asked Questions

What formula joins cells with a line break in Excel?
Use =TEXTJOIN(CHAR(10),TRUE,A2:A5) for values in A2:A5. Turn on Wrap Text to show each value on a separate visible line.

Why is my CHAR(10) line break not showing?
Enable Wrap Text for the result cell and make sure the row is tall enough. The line-feed character can be present even when the cell is not displaying it as a new line.

Can TEXTJOIN ignore blank cells?
Yes. Set its second argument to TRUE, as in =TEXTJOIN(CHAR(10),TRUE,A2:A5) for the range A2:A5. FALSE retains empty positions, which can leave blank lines.

Does TEXTJOIN work in older versions of Excel?
TEXTJOIN is available in Microsoft 365 and Excel 2019 or later. In an older version without the function, use manual concatenation with CHAR(10) for a short, fixed list, or use a compatible version of Excel.

Can Excel put each joined value in a separate row?
No. TEXTJOIN returns one text value in one cell, with line breaks inside it. To keep values in separate worksheet rows, use separate cells rather than joining them.

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.