To join text from two Excel cells with a line break between them, enter =A2&CHAR(10)&B2 in a third cell, then select that result cell and choose Home > Wrap Text. This puts both pieces of text in one cell on separate lines. Before you start, decide which cells to combine and make sure the result cell has enough width and row height to display the wrapped text.
What You’ll Need
- A workbook in Microsoft Excel for Microsoft 365 on Windows, with the text or values you want to join.
- A blank cell for the combined result. Keep the original cells unchanged until you have checked the output.
- The Wrap Text command, which makes the line break visible within the cell. Excel formulas can contain a line break even when the cell is not displaying it clearly.
Step-by-Step
-
Identify the cells and the result location. For example, suppose A2 contains North and B2 contains West. Choose C2 as the output cell. Keeping the output separate from the source cells makes it easier to check the result and change the formula later.
-
Enter the formula in the result cell. With the first text in A2 and the second text in B2, enter
=A2&CHAR(10)&B2in C2 and press Enter. The ampersands join the first cell, the line-break character, and the second cell. CHAR(10) represents a line feed, which Excel uses to create a new line inside a cell. -
Turn on text wrapping. Select C2, then go to Home > Wrap Text. This setting allows the cell to show the content on multiple lines instead of letting it appear as one long line or seem cut off. The line break is inside the cell; it does not move the following content into another worksheet row.
-
Adjust the row height if needed. If you can see only one line, select row 2 and use Home > Format > AutoFit Row Height. You can also drag the lower boundary of the row number downward. If the row height has been set manually, AutoFit may be needed to reveal the full result.
-
Check the result in the formula bar and cell. C2 should show North on one line and West on the next. Click the cell and look at the formula bar to confirm that the formula is present. The formula bar may show the text in a single line, even though the worksheet cell displays a line break.
-
Copy the formula for other records, if required. If each row has two pieces of text in columns A and B, select C2 and drag its fill handle down, or copy and paste it into the remaining result cells. Excel adjusts the relative references automatically: the next row uses A3 and B3. Check a few rows, especially where either source cell is blank.
-
Use a separator only where you need one. If a row has several fields to combine, a line break between each nonblank value may be more convenient than writing a longer chain of ampersands. With values in A2:C2, enter
=TEXTJOIN(CHAR(10),TRUE,A2:C2)in D2. This joins the cells with line breaks and ignores empty cells because the second argument is TRUE. Turn on Wrap Text in D2 as well. TEXTJOIN is available in Microsoft 365 and newer Excel versions, including Excel 2019 and later; the basic ampersand formula works in older Excel versions too. -
Keep or replace the formula deliberately. A formula result updates when its source cells change. If you need a fixed text result, copy the output cells and use Home > Paste > Paste Values. This replaces formulas with their current displayed values, so do this only after checking that the results are correct.
Common Mistakes
Forgetting Wrap Text. The formula can be correct while the cell appears to contain one line or hides some of its contents. Select the affected cell and turn on Home > Wrap Text. Then check the row height. Wrap Text controls how the content is displayed; it is not a substitute for including CHAR(10) in the formula.
Using the wrong line-break character. In a standard Excel worksheet formula, CHAR(10) is the line feed used for an in-cell new line. Typing a space, comma, or the characters n between references will not create the same break. If you copied a formula from a source that uses another spreadsheet program, check that its separator is valid in Excel.
Expecting the break to create a new worksheet row. Concatenation combines content into one cell. The new line appears within that cell, not in the cell below it. If your aim is to put each item on a separate worksheet row, use separate cells or a suitable data transformation instead of an in-cell line break.
Overwriting source data. Entering the formula in A2 or B2 when those cells contain the original text can replace the data or create a circular reference. Put the result in a separate cell, such as C2, and verify it before deleting or changing any source values.
Assuming blank cells will be omitted automatically. The ampersand formula still includes the line break if one of its referenced cells is empty, which can leave a blank-looking line. If blanks are common, consider TEXTJOIN with its ignore-empty argument set to TRUE, or revise the formula to handle blanks.
Applying the formula but not the display setting to all results. If you fill a formula down, the formulas may copy correctly while the Wrap Text setting does not apply as expected in a differently formatted destination range. Select the full output range and apply Home > Wrap Text together, then inspect row heights.
Tips
Choose a separator that suits the kind of information. For a name and a mailing address, line breaks can make the combined cell easier to scan. For short labels, a space or punctuation mark may be more appropriate than a new line. Use a line break when the pieces should remain grouped in one cell but read as separate lines.
Format the output column after testing one result. A very narrow column makes wrapped text occupy many lines, while a very wide column may make the line break less obvious. Adjust the column width to suit the sheet, then use AutoFit Row Height so the full content remains visible.
When combining many columns, decide whether blank cells should leave empty lines. TEXTJOIN’s TRUE setting skips empty cells, which is often useful for address fields that are sometimes missing. It does not remove spaces that are already inside a source cell, so trim or correct unwanted spaces in the source data if they affect the result.
Use the fill handle for repeated rows rather than changing every reference by hand. Relative references such as A2 and B2 shift when copied down. If you need to keep a reference fixed while copying, Excel supports absolute references with dollar signs, such as $A$2; only use them when you genuinely want every result to point to the same cell.
On Excel for Mac, CHAR(10) and Wrap Text work for the same purpose; use the Home tab’s Wrap Text control, though the ribbon layout can vary by version. On Excel for the web, the formula works as well, and Wrap Text is available on the Home tab. If you are editing in another spreadsheet application, its line-break formula behavior may differ.
Troubleshooting
The output looks like one long line. Select the result cell and enable Home > Wrap Text. If the text still does not visibly break, verify that the formula contains CHAR(10) between the cell references, not CHAR(32), which represents a space. Increase the row height or use AutoFit Row Height after wrapping.
The formula appears as text instead of calculating. Check whether the cell is formatted as Text. Change the number format to General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Also make sure the entry begins with an equals sign and that Show Formulas is not switched on. On Windows, Ctrl+` toggles Show Formulas; on Mac, the shortcut can vary by keyboard and Excel version, so use Formulas > Show Formulas if available.
The result has an unexpected blank line. One of the referenced cells may be empty, or it may contain a line break or spaces of its own. Click each source cell and inspect its contents. If you are combining a range and want blank cells skipped, use TEXTJOIN with TRUE as its ignore-empty argument, as shown in the steps.
The last line is hidden. The row may have a fixed height or the cell may be merged with neighboring cells. Try Home > Format > AutoFit Row Height. AutoFit can be limited for merged cells; unmerge the cell or adjust the row height manually if necessary. Also check that the font size and column width are not causing the content to take more space than expected.
You see #NAME? or another formula error. Confirm that CHAR and the cell references are spelled correctly and that parentheses are balanced. If you typed the formula into a localized Excel installation, function names or argument separators may depend on the language and regional settings. In standard English Excel, CHAR(10) and commas in the TEXTJOIN example are valid.
The formula works in one row but not the next. Check that the source cells in the later row contain the expected values and that the formula references moved to the intended row. Select the result cell and inspect the formula bar. If you copied a formula across columns instead of down rows, the references may have shifted in a different direction.
Frequently Asked Questions
What formula inserts a new line between two cells in Excel?
With the first piece of text in A2 and the second in B2, use =A2&CHAR(10)&B2 in a different cell. Turn on Wrap Text to display the break within the cell.
Do I need to press Alt+Enter to create the break?
No. Alt+Enter inserts a line break while you are manually typing or editing a cell on Windows; Mac uses Control+Option+Return in many Excel versions. In a formula, use CHAR(10) between the cell references instead.
Can I concatenate more than two cells with line breaks?
Yes. You can chain more references with ampersands and CHAR(10), or use TEXTJOIN for a range. With values in A2:C2, =TEXTJOIN(CHAR(10),TRUE,A2:C2) in D2 joins the nonblank values on separate lines. Apply Wrap Text to D2.
Will the line break remain if I copy the result to another cell?
If you copy a formula, the formula and its line-break logic copy with it, while relative references may adjust. If you copy and paste values, the resulting text, including its in-cell line breaks, is retained. Check the destination cell’s Wrap Text setting to make sure it displays properly.
Can I use a line break in a formula in Excel for the web?
Yes. CHAR(10) works in worksheet formulas in Excel for the web. Turn on Wrap Text and adjust the row height if the break is not visible. The browser version’s ribbon may look different from the Windows desktop app, but the setting is on the Home tab.
Related
- Indian Number Format in Excel: Apply Lakhs and Crores
- Excel Default Zoom: How to Set a View That Sticks Each Time
- How to Change the Color Scheme in Excel and Save It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Time Difference in Hours: Formulas and ExamplesTo calculate the difference between two Excel times in decimal hours, subtract the start time from the end…
- Excel MAX Function: Find the Highest Value in a RangeTo find the largest number in Excel, enter a formula such as =MAX(B2:B10) in an empty cell, replacing…
- Excel Named Range in a Formula: How to Use It CorrectlyIn Excel, use a named range in a formula by typing its name where you would normally put…
- Excel Filter Shortcut: How to Turn Filters On and OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a data…
- Nested IF Statements in Excel: Examples, Limits, and TipsNested IF statements in Excel put one IF function inside another, letting a formula choose among several outcomes.…
- How to Build a VLOOKUP in ExcelTo build a VLOOKUP, enter a formula that names the value to find, the lookup table, the return-column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.