Excel Text to Columns: Use a Line Break Delimiter

How-to basics · Updated November 21, 2026

To split a cell at each embedded line break in Excel for Microsoft 365 on Windows, select the cells, choose Data > Text to Columns, select Delimited, and check Other. Click the delimiter box and press Ctrl+J; the box may look empty, but it contains the line-feed delimiter. Finish the wizard to put each line in a separate column.

What the line-break delimiter does

A line break is a character stored inside a cell, not the same thing as moving to the next worksheet row. It is often inserted with Alt+Enter on Windows, or brought in when data is copied from a form, report, web page, or another application. A cell might contain an address, for example, with the street, city, and postal code on separate lines.

Excel’s Text to Columns tool normally splits text across columns. When Ctrl+J is used as the delimiter, each line-feed character marks a boundary: text before the first break goes in one output column, text between breaks in the next, and text after the last break in another. The source cell is not automatically split down rows.

In Excel, the line break commonly used inside a cell is a line-feed character, represented in formulas by CHAR(10). That is why Ctrl+J works in the delimiter box: it enters the corresponding control character. You will not see the words “Ctrl+J” or a visible symbol in the box. Do not type those characters literally; press the keys while the delimiter field is active.

Steps to split cells in the Text to Columns wizard

  1. Select the cells that contain the line breaks. If the selection includes neighboring data, check the preview and choose a safe destination so the output will not overwrite anything important.
  2. Open Data > Text to Columns. In the wizard, choose Delimited, then select Next.
  3. Check Other in the Delimiters section. Click in the small box beside Other and press Ctrl+J. Leave the box alone if it appears blank; the preview is a better indication that Excel received the delimiter.
  4. Review the preview. Each intended line should appear in its own column. If the preview still shows the whole cell as one field, click back into the box and press Ctrl+J again.
  5. Select Next. Choose a column data format if needed, and set the Destination to a blank area if you want to keep the original values. Select Finish to apply the split.

For example, if A2 contains “North” followed by a line break, then “East” followed by another line break, then “Depot,” the split produces North, East, and Depot in three adjacent columns on row 2. Other selected cells are split in the same way. If a cell has fewer lines, it will fill fewer output columns; cells with more lines may require more columns.

Preview, destination, and data-format choices

The wizard’s preview lets you catch errors before committing the split. Confirm that the breaks occur where intended and that there are enough empty columns to the right of the destination. Text to Columns writes its results into the worksheet, so an existing value in an output cell can be replaced. Set the destination to an unused range, such as a blank area farther right, when the original column must remain intact.

The final wizard step also lets you set the output format. General is convenient for ordinary text, but Excel may interpret values that look like dates or numbers. For instance, an identifier such as 00481 can lose its leading zeros if treated as a number. Choose Text for identifiers, postal codes, or other values whose exact characters matter. Choose a specific date format when you need predictable date interpretation, and inspect the result rather than assuming the default is right.

Text to Columns is not a live transformation. It changes the selected data when you finish, but it does not keep a formula connection to the source. If you need to repeat the operation as source cells change, use a formula or a refreshable data-preparation workflow instead.

Handling blank lines and repeated delimiters

Consecutive line breaks represent an empty line between two pieces of text. A leading line break creates an empty first segment, and a trailing line break creates an empty final segment. In the wizard, the option Treat consecutive delimiters as one can collapse adjacent delimiters rather than preserving the empty segment between them. Use it only if that behavior is wanted; otherwise, leave it unchecked and inspect the preview.

Empty output cells may be meaningful. In a contact record, for example, a blank line between a person’s name and phone number could reflect a missing field. Collapsing it may shift later values into the wrong positions. If blank lines are accidental, clean the source deliberately or use a transformation that lets you remove empty entries after splitting.

Common problems and fixes

  • The delimiter box looks blank: That is expected for Ctrl+J. Check the preview; the control character has no ordinary visible glyph.
  • Nothing splits: Re-select the Other box and press Ctrl+J. Make sure Delimited is selected and that the actual cell contains an embedded line break rather than a visual wrap caused by a narrow column.
  • Text wraps but does not split: Wrap Text only changes how content is displayed. A cell can appear on several screen lines because of wrapping without containing a line-break character. Widen the column or inspect the cell contents before splitting.
  • Some records create more columns than expected: Their cells contain more line breaks. Check the source data and make sure the destination area has room for the widest record.
  • Values change after splitting: Excel may have converted text to numbers or dates. Undo immediately with Ctrl+Z if appropriate, then repeat the operation and set the relevant output column format to Text.
  • Other characters split too: Confirm that Tab, Comma, Space, and other delimiter boxes are unchecked unless you intend to use them as additional separators.

Also distinguish a line break from a carriage return. Imported text can contain different combinations of control characters depending on its source. Ctrl+J targets the line-feed character normally used for breaks inside Excel cells. If a pasted file does not split as expected, clean or normalize the imported text first, or use Power Query to inspect and transform the source.

When to use a formula instead

A formula is useful when you want a repeatable result that updates if the original cell changes, or when you need to split a single cell without running a wizard over a range. In Microsoft 365 or Excel 2024, TEXTSPLIT can use the line-feed character as its column delimiter.

With the full text in A2, enter =TEXTSPLIT(A2,CHAR(10)) in a blank cell. If A2 contains North, East, and Depot on separate lines, the formula spills North, East, and Depot into neighboring columns. Leave those spill cells empty, or Excel will return a spill error because it cannot place the results over existing content. The formula result updates when A2 changes.

TEXTSPLIT also has a row-delimiter argument. With the same text in A2, =TEXTSPLIT(A2,,CHAR(10)) splits at line breaks vertically, placing North, East, and Depot in separate rows. The empty second argument leaves the column delimiter unspecified, while CHAR(10) is supplied as the row delimiter. These dynamic-array formulas require Microsoft 365 or Excel 2024; they are not available in every older Excel release.

Splitting into columns versus splitting into rows

Text to Columns is the direct choice when each line should become a field on the same worksheet row—for example, turning a multiline address into street, city, and postal-code columns. It is quick for a one-time cleanup and gives a preview and output-format controls.

If each line needs to become a separate record in a vertical list, Text to Columns is not the right orientation. Use the vertical TEXTSPLIT formula above in a supported Excel version, or use Power Query for a repeatable import and transformation. Power Query is particularly useful for larger datasets and recurring files, though its steps take more setup than a one-time wizard operation.

Excel for Mac and Excel for the web

On Excel for Mac, the Text to Columns command is also available from the Data tab, although the wizard’s appearance can differ by release. The delimiter is still a line-feed character; click the Other field and try Control+J. If the key combination is intercepted or does not appear in the preview, use a formula with CHAR(10) where TEXTSPLIT is available, or clean the data in a desktop version of Excel.

Excel for the web has different feature availability and interface details from desktop Excel. If Text to Columns is not available in the web version you are using, open the workbook in desktop Excel or use TEXTSPLIT in a version that supports it. In all versions, splitting creates separate values; it does not preserve the original cell’s multiline formatting as a single value.

Frequently Asked Questions

Can I use Alt+Enter as the Text to Columns delimiter?
Alt+Enter inserts a line break while editing a cell on Windows; it is not the key sequence to enter in the wizard. In the Other delimiter box, press Ctrl+J to specify the line-feed character.

Why does Ctrl+J leave the delimiter box looking empty?
Ctrl+J enters a nonprinting control character, so the box may show no visible mark. The preview should show the split. If it does not, click the box and press Ctrl+J again.

Does Text to Columns put each line on a new row?
No. It puts each segment in a separate column on the same row. Use a vertical TEXTSPLIT formula with CHAR(10) as its row delimiter, or another transformation method, when you need separate rows.

Can I split only at line breaks and not at spaces?
Yes. Select only Other and enter Ctrl+J in its box. Make sure Space and the other delimiter checkboxes are off.

Will the split update when I edit the original cell?
No. Text to Columns writes a one-time result. Use TEXTSPLIT in Microsoft 365 or Excel 2024 if you want a formula result that recalculates when the source cell changes.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.