Excel Text Join With a New Line: Formulas and Tips

To join text with a new line in Excel, use TEXTJOIN with CHAR(10) as the delimiter. With text in A2:A4, enter =TEXTJOIN(CHAR(10),TRUE,A2:A4); then turn on Wrap Text to see each cell’s text on its own line inside the result cell.

What a new-line delimiter does

A delimiter is the text or character Excel inserts between the items being joined. A comma, space, or dash is a visible delimiter; CHAR(10) represents a line-feed character, which starts a new line within a cell. The formula still produces one result in one cell, but that result contains line breaks between its items.

For example, if A2 contains Ada, A3 contains Ben, and A4 contains Chen, the formula in the opening paragraph returns Ada, Ben, and Chen on three separate lines in the result cell. It does not put the names into three worksheet rows. Use a new-line join when you want a compact, multi-line label, address, note, or summary in a single cell.

TEXTJOIN combines a delimiter, a setting for empty cells, and one or more text values or ranges. It is available in Excel 2019 and later, including Microsoft 365. In Excel for Microsoft 365 on Windows, the comma-separated formula shown here is standard. Some regional settings use semicolons as formula separators, so Excel may display or require different separators depending on the installation.

Build a basic multi-line formula

For a simple list, put the source text in a continuous range and use that range as the final argument. With names in A2:A4, enter =TEXTJOIN(CHAR(10),TRUE,A2:A4). The result is three lines in the order the names appear in the cells. The first argument supplies the line break, and TRUE tells Excel to ignore empty cells.

To create the result:

Select the cell where the combined text should appear.
Type the formula, adjusting A2:A4 to match the actual source range.
Press Enter. If the result appears as one long line, select the result cell and choose Home > Wrap Text.
Adjust the row height if needed. You can drag the row boundary, or double-click the boundary below the row number to fit the row to its contents.

The source cells remain unchanged. The formula result updates when the source text changes, so this approach is useful for summaries that need to stay synchronized with a list. If the order matters, arrange the source rows in the desired order before joining them; TEXTJOIN follows the order of the supplied range and does not sort it.

Choose whether to skip empty cells

The second argument in TEXTJOIN controls what happens when a source cell is empty. With text in A2:A5, where A3 is empty, =TEXTJOIN(CHAR(10),TRUE,A2:A5) returns the nonblank entries with no extra empty line for A3. This is usually the best choice for a list where some optional fields may be missing.

Set that argument to FALSE when the position of empty cells matters. With Ada in A2, an empty A3, and Chen in A4, =TEXTJOIN(CHAR(10),FALSE,A2:A4) includes the delimiter for the empty cell, leaving a blank line between Ada and Chen. This can preserve a fixed layout, but it can also make the result look as if it has an accidental gap.

A cell containing a formula that returns an empty string is generally treated as empty for the ignore-empty behavior. A cell containing one or more spaces is not truly empty: the spaces can remain in the output and may look like a blank line. If a result has unexpected gaps, inspect the source cells for spaces as well as for formulas that return empty text.

Make line breaks visible in the worksheet

The line-feed character is part of the formula result, but the cell’s display settings affect how it appears on screen. Select the result cell and choose Home > Wrap Text. With wrapping enabled, Excel can display the content on multiple lines within the cell. Without wrapping, the line breaks may not be obvious, and the text can appear clipped or difficult to read.

Wrapping does not change the value or insert additional worksheet rows. It only changes how the cell displays its content. If the row is too short, part of the result may be hidden. AutoFit Row Height or a manually increased row height can reveal the full result. Merged cells and manually fixed row heights can complicate automatic sizing, so check those settings if the last line remains out of view.

For a line break typed directly into a cell rather than generated by a formula, Windows Excel uses Alt+Enter while editing the cell. On Excel for Mac, the shortcut is Control+Option+Return. The shortcut adds a break at the insertion point; it is different from turning on Wrap Text, which allows Excel to wrap a long line automatically at the cell boundary.

Use concatenation for a fixed number of cells

TEXTJOIN is concise for a range or a changing number of items. If you have only a few fixed cells and need compatibility with older Excel versions, the concatenation operator & can join text and line breaks directly. With text in A2, A3, and A4, enter =A2&CHAR(10)&A3&CHAR(10)&A4. If those cells contain Ada, Ben, and Chen, the result has those three names on separate lines.

This method spells out each cell reference, so it becomes cumbersome when the list grows or changes length. It also inserts a break between every reference, even if one of the cells is blank. That may be appropriate when the positions have fixed meanings, but it is less convenient than TEXTJOIN for a variable list or for skipping empty fields.

Do not confuse a line break with a space. A formula such as =A2&" "&A3 places the contents on one line with a space between them. Use CHAR(10) when the desired separator is a new line. You can also use a combination of text and a line break as a delimiter when each item needs a label or punctuation, but keep the separator consistent so the combined result remains readable.

Practical uses and a labeled example

A multi-line join is handy when you need to turn separate fields into one display value. Common cases include a mailing address, a contact card, a short list of tasks, or a product description assembled from several columns. It is especially useful when another system or a report expects one cell to contain the complete text block.

Suppose A2 contains the name, B2 the street address, and C2 the city and postal code. With those fields in A2:C2, =TEXTJOIN(CHAR(10),TRUE,A2:C2) combines the three values into a three-line address, skipping fields that are empty. This works well when the fields are already in the order you want to display them.

If you want labels such as Name: or City:, those labels must be included in the joined text rather than inferred by TEXTJOIN. For a small fixed layout, concatenate the labels with their cell references and insert CHAR(10) between the lines. For a larger template, consider placing the labels and values in separate source cells, then joining the prepared text cells. That keeps the assembly logic easier to inspect and change.

Remember that a joined result is text, not a structured address or a set of separate values. It may look like several lines, but Excel cannot automatically treat each line as a separate record for sorting or calculations. Keep the original fields in their own cells if you will need to filter, sort, validate, or reuse them individually.

Common problems and fixes

The result stays on one visible line: Select the result cell and choose Home > Wrap Text. Then check that the row is tall enough to show all lines.
There are unwanted blank lines: Use TRUE for the ignore-empty argument, and check whether source cells contain spaces rather than being empty.
The formula shows an error or is rejected: Check that the range references are valid and that parentheses are balanced. Depending on regional settings, Excel may require semicolons instead of commas between arguments.
The line break appears in an unexpected place: Check the order of the source cells and whether the formula includes the intended range. A line break occurs wherever the delimiter is inserted.
The last line is cut off: Increase the row height or use AutoFit Row Height. A fixed height or merged cell can prevent the full result from displaying automatically.

When copying a formula, also check whether its references should move. Relative references such as A2:A4 adjust when copied to another location. If the formula must always use the same source range, use absolute references such as $A$2:$A$4. The dollar signs lock the reference when the formula is copied; they do not change how the line breaks work.

Compatibility and platform notes

The main method uses TEXTJOIN, which is available in Excel 2019, Excel 2021, Excel 2024, and Microsoft 365. The simpler & method can be used when working in older versions that do not support TEXTJOIN. Both approaches use CHAR(10) for the line-feed character in Excel formulas.

In Excel for Mac, the formula approach and the Wrap Text control work in much the same way as in Windows Excel. The keyboard shortcut for inserting a manual line break differs, as noted above. Excel for the web also supports formulas and cell wrapping, although its editing controls and keyboard behavior can differ from the desktop app. If a workbook is shared across platforms, check the displayed row height and wrapping after opening it in the other version.

Line breaks are part of the cell’s text value, not merely a visual effect. If you copy the result into another program, that program may preserve the breaks, convert them, or display the text differently. Test the final output in the destination application when the exact formatting matters.

Frequently Asked Questions

What formula joins cells with a line break in Excel?
Use =TEXTJOIN(CHAR(10),TRUE,A2:A4) when the text is in A2:A4. Replace the range as needed, then turn on Wrap Text to display each item on a separate line.

Why is CHAR(10) used for a new line?
CHAR(10) returns the line-feed character Excel uses as a line break within a cell. It can serve as the delimiter in TEXTJOIN or be combined with cell references using &.

How do I join cells and skip blanks?
Set the second argument of TEXTJOIN to TRUE. For example, with text in A2:A10, =TEXTJOIN(CHAR(10),TRUE,A2:A10) leaves empty cells out rather than adding a blank line for each one.

Do I need Wrap Text for the formula to work?
No. The formula can contain line-feed characters without Wrap Text, but the cell may not display the lines clearly. Turn on Wrap Text and give the row enough height to show the complete result.

Can I insert a new line manually in a cell?
Yes. While editing a cell in Windows Excel, press Alt+Enter at the desired point. In Excel for Mac, use Control+Option+Return. For a formula-generated list, use CHAR(10) instead.

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.