How to Add a New Line in Excel CONCATENATE

Formulas & functions · Updated November 20, 2026

To add a new line between text values joined with Excel’s CONCATENATE function, insert CHAR(10) between the cell references, then turn on Wrap Text for the result cell. For example, with a first name in A2 and a last name in B2, use =CONCATENATE(A2,CHAR(10),B2). This puts the two values on separate lines inside one cell; it does not move the second value into another cell.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows, or an Excel version with the CONCATENATE function. The instructions also work in current Excel for Mac and Excel for the web, though ribbon layouts can look slightly different.
  • The cells containing the text you want to join, plus an empty cell for the result.
  • Wrap Text enabled on the result cell so the line break is visible within the cell.

Step-by-Step

  1. Prepare the source cells. Put each piece of text in its own cell. For the example below, enter Ada in A2 and Lovelace in B2. The formula will combine them in that order. If your information is in other columns or rows, you can use those cell references instead.
  2. Select an empty result cell. Click a cell where you want the combined text to appear, such as C2. Keeping the result in a separate column preserves the original values, so you can correct or reuse them later. Do not type the formula into A2 or B2, because that would replace source data.
  3. Enter the CONCATENATE formula. With Ada in A2 and Lovelace in B2, and C2 selected as the result cell, enter =CONCATENATE(A2,CHAR(10),B2). The first argument supplies the text from A2, CHAR(10) inserts a line-feed character, and the final argument supplies the text from B2. Press Enter to calculate it.
  4. Check the result. With A2 containing Ada and B2 containing Lovelace, the displayed value in C2 should read Ada on the first line and Lovelace on the next line. The break is part of the contents of C2, even if the row is not tall enough to show both lines immediately.
  5. Turn on Wrap Text. Keep C2 selected, then choose Home > Wrap Text on the ribbon. In Excel for Mac, use the Home tab’s Wrap Text command as well; in Excel for the web, select the cell and look for Wrap Text on the Home tab. This setting lets Excel display the line-feed character as a new visual line within the cell.
  6. Adjust the row height if needed. If only one line appears, select row 2 and choose Home > Format > AutoFit Row Height, or drag the row boundary downward. You can also double-click the lower edge of the row number. The cell may already contain a line break; a short row can simply hide the rest of its content.
  7. Apply the formula to more rows. If each row has corresponding text in columns A and B, select C2 and drag the fill handle, the small square at the lower-right corner of the selected cell, down the column. Excel adjusts the references for each row. For example, the next row will use A3 and B3. Check a few results to confirm that each record is paired correctly.
  8. Choose a different line-break pattern if useful. To put a blank line between the two values, with the same A2 and B2 source cells and C2 as the result cell, use =CONCATENATE(A2,CHAR(10),CHAR(10),B2). Two line-feed characters create an empty line between the values. If the extra spacing is too large, return to one CHAR(10).
  9. Join three or more pieces of text. With a street in A2, a city in B2, and a postal code in C2, and D2 selected for the result, use =CONCATENATE(A2,CHAR(10),B2,CHAR(10),C2). This puts each value on its own line. Replace the sample references with the cells in your worksheet, keeping a line-break argument wherever you want a new line.

The same idea works with the ampersand operator, which joins text without calling CONCATENATE. With the first value in A2, the second in B2, and C2 selected as the result cell, enter =A2&CHAR(10)&B2. It produces the same line break, and C2 still needs Wrap Text enabled. Use whichever approach is easier to read in your workbook; the CONCATENATE version may be clearer if you are already using that function.

Common Mistakes

  • Forgetting Wrap Text. The formula can calculate correctly while the cell appears to show one continuous line or only the first line. Select the result cell and enable Wrap Text before changing the formula. The line-feed character does not always look obvious in the formula bar.
  • Using a space instead of a line break. A space separates words but keeps them on the same line. Use CHAR(10) for a new line within the cell. If you want a space as well as a line break, include a space in the source text or add it as a separate text argument; do not assume the line break adds punctuation or spacing.
  • Putting CHAR(10) outside the joined text. The line-feed argument must be included between the values in the formula. If it is left out, CONCATENATE joins the text directly. If you put it before both values or after both, the break appears at the beginning or end rather than between them.
  • Expecting a new row or cell. CHAR(10) changes the display inside the result cell. It does not insert a worksheet row, split data into separate cells, or change the source values. Use a different formula or a data-splitting tool if the goal is to create separate cells.
  • Overwriting source values. Entering the formula into one of the cells it refers to can remove the original input or create a circular reference. Put the result in a different cell, then copy and paste values later only if you no longer need the formula.

Tips

  • Use the formula bar to inspect a result. Click the output cell and check the formula bar to confirm the line break is in the formula where expected. The cell display is for reading; the formula bar is useful for checking the expression itself.
  • Make the column wide enough for the longest line. Wrap Text controls vertical display, but very narrow columns create extra wrapped lines inside each intended line. Widening the column can make addresses, labels, or names easier to read without changing the formula.
  • Keep source values clean. Leading or trailing spaces in an input cell remain when you join it. They can make the start or end of a line look oddly indented. Edit the source data if possible; inspect the formula bar if an apparent blank seems to remain beside a value.
  • Use one line break between ordinary lines. Multiple CHAR(10) entries add blank space and increase the row height. Start with one break between each pair of fields, then add another only when a deliberate blank line improves readability.
  • Remember that the result is formula-driven. If A2 or B2 changes, C2 recalculates. If you need a fixed text snapshot, copy the result and use Paste Special > Values. Keep a copy of the workbook or the formula first if you might need to update the combined text later.
  • Choose the joining method that fits your sheet. CONCATENATE remains available for compatibility with older workbooks. The ampersand operator is a compact alternative. Both can include CHAR(10), and both rely on Wrap Text for a clear multi-line display.

Troubleshooting

The output stays on one line. First select the output cell and choose Home > Wrap Text. If it is already on, check that the formula includes CHAR(10) between the source references, not just a regular space. Then make the row taller or use AutoFit Row Height. If the column is extremely narrow, widen it because the intended lines may wrap again within themselves.

The formula displays as text instead of calculating. Check that it begins with an equals sign and that the cell is not formatted as Text. Change the cell format to General, then select the formula, press F2, and press Enter to make Excel recalculate it. Also check whether a leading apostrophe was typed before the equals sign; remove it if present.

You see a formula error. Confirm that the function name is spelled CONCATENATE, the arguments are separated by commas in the Windows setup described here, and each parenthesis is closed. If your regional Excel settings use semicolons as argument separators, replace the commas with semicolons; the line-break function remains CHAR(10). Make sure the referenced cells are valid and that you have not accidentally deleted a parenthesis while editing.

The line break is in the wrong place. Move CHAR(10) to the exact position where one line should end. The order of arguments determines the order of the text. For example, if the city should appear above the street, reverse the references around the break. If you see unwanted empty lines, remove any extra line-feed arguments.

Only part of a line is visible. Increase the row height or select AutoFit Row Height. Also check for merged cells, which can make automatic row sizing behave unexpectedly. If automatic sizing does not fix a merged result cell, adjust its row height manually. Zoom level changes how the sheet appears on screen, but it does not remove the stored line break.

The formula works in one row but not the others. Check that the fill handle copied the formula down and that the references point to the matching source cells on each row. If you copied and pasted rather than dragging, inspect whether the formula references shifted as intended. A blank source cell can also produce an apparently empty line, so check the input row itself.

Frequently Asked Questions

What does CHAR(10) do in Excel?
It returns the line-feed character, which Excel can use as a line break inside a text value. When used between CONCATENATE arguments, it separates the displayed text onto another line in the same cell.

Do I have to use Wrap Text?
For a reliable in-cell display, yes. The formula can contain the line-feed character without Wrap Text, but Excel may not show the separate lines clearly. Turn on Wrap Text for the result cell and adjust the row height if needed.

Will this work on Excel for Mac or the web?
Current Excel for Mac and Excel for the web support CHAR(10) and CONCATENATE. The ribbon may be arranged differently, but look on the Home tab for Wrap Text. The formula and cell setup are otherwise the same.

Can I add more than one new line?
Yes. Put another CHAR(10) in the formula for every additional line-feed character. Two consecutive line feeds create a blank line between text values. More line feeds also require more row height.

Can I use CONCAT instead of CONCATENATE?
Yes. In Microsoft 365, CONCAT is another option for joining text. With the same source values in A2 and B2 and C2 as the result cell, the equivalent formula is =CONCAT(A2,CHAR(10),B2). Enable Wrap Text as you would with CONCATENATE. The ampersand version works too.

Can I use this to insert a line break while typing in a cell?
Yes, but that is different from joining cells with a formula. While editing a cell on Windows, press Alt+Enter at the point where you want the manual break, then make sure Wrap Text is enabled. This changes that cell’s typed content; it does not create a formula that updates from other cells.

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.