Excel Text to Columns: Split Alt+Enter Line Breaks

How-to basics · Updated November 21, 2026

To split text entered with Alt+Enter in Excel, use Data > Text to Columns, choose Delimited, select Other, and press Ctrl+J in the delimiter box. Alt+Enter creates the line break inside a cell; Ctrl+J supplies that line break as the delimiter. The box may look blank after you press it—that is normal.

What Alt+Enter does in an Excel cell

In Excel for Windows, Alt+Enter inserts a line break within the cell you are editing. It does not move the content into another cell. For example, one cell might contain the text North, a line break, and then South. The two words are still stored in a single cell, even though they appear on separate lines when the cell is tall enough to show them.

That embedded break is different from pressing Enter to finish editing a cell and move the selection. It is also different from a tab, comma, or ordinary space, which Excel lists as familiar delimiters in the Text to Columns wizard. Because the line break is a control character rather than a visible character, it is not practical to type it into the wizard as if it were a normal word or symbol.

When Excel inserts a line break with Alt+Enter, it is generally represented as a line-feed character. Ctrl+J is the keyboard entry used in the delimiter field to specify that character. Knowing the distinction clears up a common search question: Alt+Enter is how a user can create the break in a cell; Ctrl+J is how to identify that break as the delimiter for this operation.

Split line breaks with Text to Columns

These steps apply to Excel for Microsoft 365 on Windows. First, make a copy of the source column or workbook if the original text needs to be preserved. Text to Columns writes its result into cells, so existing data to the right can be overwritten if you do not choose a safe destination.

  1. Select the cells containing the line breaks. If you select a whole column, Excel applies the operation to the selected cells that contain data.
  2. Choose Data > Text to Columns on the ribbon.
  3. In the Convert Text to Columns Wizard, choose Delimited, then select Next.
  4. Clear other delimiter checkboxes, such as Tab, Comma, or Space, unless you also want those characters to split the text.
  5. Select the Other checkbox, click its small input box, and press Ctrl+J. The box can remain visually empty; the line-feed character does not display as a printable symbol.
  6. Select Next. In the final wizard step, check the data preview and choose a destination with enough empty columns if you do not want to replace the source cells.
  7. Select Finish and confirm any prompt about replacing existing data only if the destination is correct.

The first piece of each cell’s text occupies the first output cell, and later pieces go into cells to its right. For instance, a cell containing a name, a line break, and an email address can become two adjacent cells: the name in the first and the address in the second. Text to Columns does not automatically put the pieces into separate rows.

Why Ctrl+J works—and why the box looks blank

Ctrl+J is not a special Excel delimiter name. It enters a nonprinting line-feed character into the wizard’s Other field. Since that character means “start a new line,” it has no ordinary glyph for Excel to show in the box. The checkbox can be selected while the input area appears empty, which is why people sometimes think their keystroke did not register.

Check the data preview in the wizard before finishing. If the preview shows the text divided at the line breaks, the delimiter was recognized. If it remains as one piece, click the Other field again and press Ctrl+J once more. Make sure the Other checkbox is checked and that a different checked delimiter is not also splitting the data at unwanted characters.

Do not type the characters Alt+Enter, Ctrl+J, or the words line break into the Other box. Those would be ordinary text, not the hidden delimiter. Likewise, pressing Alt+Enter while the wizard is open is not the way to specify the character; Alt+Enter is the cell-editing shortcut that originally creates an in-cell break.

Plan the output and preserve the original text

Text to Columns is a transformation, not just a preview. By default, the first result uses the selected source location, with additional pieces placed in columns to its right. If those cells contain formulas, notes, or other values, the operation can replace them. Before clicking Finish, use the wizard’s Destination field to specify an empty starting cell when you want the original column left in place.

Think about the greatest number of line-separated pieces in any selected cell. Excel needs enough columns to hold that widest result. If most cells have two lines but one has five, that row can occupy five output columns. Check the preview for long or irregular entries, and leave a suitable number of empty columns beyond the chosen destination.

The final wizard step also lets you choose how a column is interpreted. General formatting may convert text that resembles a number or date into a numeric value or date. If a piece must remain exactly as written—for example, an ID with leading zeros—select the relevant output column in the preview and choose Text before finishing. This helps prevent a split operation from changing the appearance or meaning of codes.

Empty lines, extra breaks, and other delimiters

Two line breaks in a row create an empty segment between them. This can happen when a cell has a blank line between paragraphs or ends with an extra break. In the wizard, Treat consecutive delimiters as one can collapse adjacent delimiters rather than preserve empty pieces. Whether to check it depends on the data: turn it on if repeated breaks should count as one separator; leave it off if blank segments represent meaningful positions you need to retain.

A line break may not be the only separator in the selected text. If you leave Tab, Comma, Space, or another option checked, Excel will split at those characters too. For example, selecting both line feed and Space could turn a phrase on one line into several columns at each word boundary. For a pure Alt+Enter split, clear the unrelated delimiter choices and use only Other with Ctrl+J.

Also distinguish a displayed wrap from an actual break. With Wrap Text enabled, Excel can display a long line on multiple visual lines simply because the column is narrow. That does not necessarily mean the cell contains an Alt+Enter character, so Text to Columns will not split it at the visual wrap. Widen the column or inspect the cell while editing to determine whether a real in-cell break exists.

What to check when the split does not work

  • The preview stays unchanged: Check that Other is ticked and Ctrl+J was pressed while focus was in its input field. Click the field first rather than relying on the checkbox alone.
  • The text splits in unexpected places: Clear other delimiter options and inspect whether spaces, commas, or tabs should actually be separators.
  • Output disappears or overwrites something: Undo immediately with Ctrl+Z if possible, or restore the backup. Next time, choose an empty destination and verify the columns to its right are clear.
  • Blank columns appear: Look for consecutive line breaks, leading breaks, or a trailing break. Decide whether empty segments matter before changing the consecutive-delimiter setting.
  • Numbers or dates change: In the wizard’s final step, set the affected output column to Text before finishing, especially for identifiers and values with leading zeros.

If the data came from another application or a website, its line endings may differ from the Alt+Enter line feed Excel normally creates. A pasted character can look like a line break without being exactly the same control character. If Ctrl+J does not split the preview, try the formula approach below or clean a copy of the data in a helper column; avoid applying multiple destructive conversions to the only original copy.

Formula alternative with TEXTSPLIT

In Microsoft 365 and Excel 2024, TEXTSPLIT can separate a line-break-delimited value without using the wizard. With the complete text in A2, enter this in B2 to return the pieces across columns:

=TEXTSPLIT(A2,CHAR(10))

If A2 contains North, a line break, and South, the formula spills North into B2 and South into C2. The original value in A2 remains unchanged. Make sure the cells where the results need to spill are empty; otherwise Excel reports a spill error. TEXTSPLIT is useful when source text changes and you want the split result to update automatically, whereas Text to Columns is a one-time transformation of the selected values.

To return the same pieces vertically instead, with the text still in A2 and the formula entered in B2, use:

=TEXTSPLIT(A2,,CHAR(10))

The third argument specifies a row delimiter, so North and South spill into B2 and B3. TEXTSPLIT requires Microsoft 365 or Excel 2024; it is not available in every older Excel release. If the result contains unwanted empty items because the text has repeated line breaks, TEXTSPLIT has an optional argument for ignoring empty pieces, but check the function’s argument order and preview your results before relying on that behavior.

Splitting into rows instead of columns

The name Text to Columns describes the direction of its output: the pieces spread across columns in the same row. If the goal is a list with one piece per row, Text to Columns alone is not the direct solution. You can split into columns and then copy the results and use Paste Special > Transpose in a suitable empty location, or use TEXTSPLIT with a row delimiter as shown above when your Excel version supports it.

Choose the direction based on what you plan to do next. Separate columns are convenient when each line represents a different field, such as a person’s name and phone number. Separate rows are often more useful when each line is an item in a list that will be filtered, sorted, or analyzed as a record. If different cells contain different numbers of lines, a vertical result may also need additional cleanup so the lists stay associated with their original records.

Excel for Mac and Excel for the web

On current Excel for Mac, Text to Columns is available from the Data tab, but keyboard shortcuts and dialog behavior can differ from Windows. The steps above specifically use the Windows Ctrl+J entry method; if that keystroke does not put a line feed in the Mac wizard’s Other field, use TEXTSPLIT where available or check the preview before committing any change. Excel for the web also varies in the commands exposed by its interface, so do not assume every desktop wizard control is present. TEXTSPLIT is a practical option in Microsoft 365 editions that include the function.

Frequently Asked Questions

Is Alt+Enter the delimiter in Text to Columns?
No. Alt+Enter inserts an in-cell line break while editing a cell in Excel for Windows. In Text to Columns, choose Other and press Ctrl+J to specify the line-feed character as the delimiter.

Why does Ctrl+J not appear in the delimiter box?
Ctrl+J enters a nonprinting line-feed character, so there is no visible symbol to display. Confirm that Other is checked and use the wizard’s preview to see whether Excel recognized the separator.

Does Text to Columns split one cell into multiple rows?
No. It puts the separated pieces into columns on the same row. To make a vertical list, transpose the output or use TEXTSPLIT with a row delimiter in a supported Excel version.

Will Text to Columns keep my original cell?
Not by default if the output starts in the source location. Choose an empty destination in the wizard to preserve the original, and ensure there is enough empty space to the right for all resulting columns.

Can I use this for line breaks pasted from another program?
Often, yes, if the pasted break is a line-feed character. If the preview does not split with Ctrl+J, the source may use a different line-ending character; test a copy or use a formula or cleanup step rather than risking the only original data.

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.