Excel Text to Columns: Split a Cell at Line Breaks

How-to basics · Updated November 21, 2026

To split text at an in-cell line break in Excel for Microsoft 365 on Windows, select the cells and choose Data > Text to Columns > Delimited. Select Other, click its delimiter box, press Ctrl+J, and finish the wizard. The line-feed character is invisible in the box, but Excel can use it to divide each cell’s contents into separate columns.

What Excel Means by a Carriage Return

People often say carriage return when they mean a line break inside an Excel cell. The distinction matters because computers represent line endings with control characters. In Excel, a line break inserted within a cell is generally a line-feed character, represented by CHAR(10). That is the character entered as the Text to Columns delimiter with Ctrl+J on Windows.

A true carriage return is a different character, represented by CHAR(13). Some text files use a carriage return and line feed together to mark the end of a record. Excel may handle those file-ending characters when importing data, but they are not necessarily the same thing as a deliberate line break within one cell. In everyday use, Ctrl+J is the usual delimiter for splitting text on a visible, in-cell line break.

To check whether a cell contains a line break, select it and look in the formula bar, or turn on Home > Wrap Text to display multiple lines within the cell. A wrapped line caused only by a narrow column is not a line-break character; it is just text flowing onto another visual line. Text to Columns will not split at that kind of wrapping.

Split a Cell with Text to Columns

Text to Columns divides the contents of each selected cell into neighboring columns. The original value is replaced by the first part, and later parts are placed to its right. Follow these steps in Excel for Microsoft 365 on Windows:

  1. Select the cells in the column that contain the line breaks. Selecting only the relevant data helps prevent unintended changes to other columns.
  2. Choose Data > Text to Columns to open the Convert Text to Columns Wizard.
  3. Choose Delimited, then click Next. A line break is a delimiter between text pieces, just like a comma or tab.
  4. Clear delimiter options you do not want to use. Select Other, click in its text box, and press Ctrl+J. The box may look empty because the line-feed character cannot be seen.
  5. Check the data preview. The line-break-separated pieces should appear in separate columns. Click Next if you need to set column formats, or click Finish to use the defaults.

For example, if A2 contains the two lines North and South, splitting on the in-cell line break puts North in A2 and South in B2. If the same row in other cells contains three pieces, Excel can fill a third column for those rows as well.

Choose a Safe Destination and Review the Results

Before you click Finish, consider where the output will go. By default, Text to Columns writes the results starting in the selected column. If the cells to the right already contain information, the split may overwrite it. Make room first, or set a different destination in the wizard’s final step. A safe practice is to copy the source column to a blank area or a duplicate worksheet before transforming important data.

After the split, inspect several rows, including the shortest and longest entries. Rows with fewer line breaks will have fewer populated output columns; depending on the data, remaining cells may appear blank. Check that names, addresses, notes, or other values have not been shifted into the wrong fields. If the original cell contains a trailing line break, the final piece may be empty.

Text to Columns is a data transformation, not a display change. Undo it immediately with Ctrl+Z if the result is wrong. Once you have continued working or saved and closed the workbook, restoring the original layout may take more effort, which is another reason to keep a copy of the source data.

Why the Delimiter Box Looks Empty

Ctrl+J enters a control character rather than a printable letter. It is normal for the Other box to remain visually blank after the shortcut. The preview is the useful confirmation: if each line-separated piece appears in a separate column, Excel recognized the delimiter. If the preview does not change, the selected cells may not contain the line-feed character you expect, or the shortcut may not have entered it.

Do not type the characters CHAR(10) into the Other box. That text is a notation used in formulas; it is not the actual delimiter. Similarly, typing a space or a visible symbol will split at that character, not at an in-cell line break. If you are unsure what the source contains, test the method on a copy of one cell before applying it to a full column.

Common Problems and How to Fix Them

  • The text does not split: Confirm that the cell contains an actual line break, not ordinary wrapping. Reopen the wizard and enter Ctrl+J in the Other box. If the data came from an external file, its embedded breaks may use a different control character.
  • Text splits at commas or tabs too: Clear the other delimiter checkboxes unless those separators should also divide the text. Text to Columns applies every selected delimiter.
  • Data to the right disappears: The wizard writes results into adjacent cells. Undo at once if possible, then make room or choose a blank destination before trying again.
  • Some rows have extra blank columns: Rows may contain different numbers of line breaks, or a line break may be present at the start or end. Review the source and decide whether blank pieces should be kept or removed.
  • Quotes or punctuation behave unexpectedly: The wizard has a text qualifier setting, commonly a double quote. If the input includes quoted text, inspect the preview and check whether the qualifier is causing characters to be treated specially.

A frequent misconception is that every visual new line is a carriage return. A narrow column can wrap a long sentence without adding any character to the cell. Conversely, a cell can contain a line break even if its row height or formatting makes that break hard to notice. The distinction explains why the preview may show no split for text that looks like it occupies two lines.

Use a Formula Instead of Changing the Source

If you want the original cell to remain intact and have the split update when its value changes, a formula can be more convenient. In Microsoft 365 or Excel 2024, the TEXTSPLIT function can divide text across columns using the line-feed character as its column delimiter.

Assuming the original text is in A2, enter =TEXTSPLIT(A2,CHAR(10)) in an empty cell outside the source data. For the example North followed by South in A2, the formula returns North in the formula cell and South in the next column. The results spill into neighboring cells, so those cells must be clear. Unlike Text to Columns, the formula keeps A2 unchanged and recalculates when A2 changes.

If TEXTSPLIT is unavailable in your Excel version, use the wizard or a data-cleaning workflow that supports the version you have. Do not paste the formula over its own source cell: the result needs a separate output area. Also note that the formula above splits at line feeds; if a source contains carriage-return characters instead, first identify and normalize the data rather than assuming the two characters are interchangeable.

Windows, Mac, and Excel for the Web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac also provides Text to Columns under the Data tab, but keyboard shortcuts can differ by keyboard and application. If Ctrl+J does not enter the hidden delimiter on your Mac, use a separate output area and the TEXTSPLIT formula where available, or clean the data in Power Query if that option is part of your workflow. Verify the output before replacing the source.

Excel for the web may not offer the same Text to Columns wizard experience as the Windows desktop app. If the needed command is not available in your browser session, open the workbook in the desktop version, or use a supported formula such as TEXTSPLIT. Availability of newer functions can depend on the Excel version and update channel; TEXTSPLIT is available in Microsoft 365 and Excel 2024.

When to Use Text to Columns, a Formula, or Power Query

Text to Columns is a good choice for a one-time split when you want fixed values in separate columns. It is quick, works directly on a selected range, and does not require building a formula. Its main trade-off is that it changes the worksheet data and does not automatically repeat the transformation when new rows arrive.

Use TEXTSPLIT when you want a live result linked to a source cell, or need to keep the original intact. Its spill output is useful for a small or regularly updated worksheet, but the destination must remain clear and the function must exist in the Excel version being used.

Power Query is worth considering for recurring imports or larger cleanup jobs. It can transform data as part of a repeatable query-refresh process, though the exact steps depend on the shape of the source and the Excel build. For a single column that needs a one-off split, the wizard is often simpler. In all cases, check whether the source’s line breaks are within a field or are actually separating records; splitting record separators as though they were part of a cell can disrupt the table structure.

Frequently Asked Questions

What shortcut splits on a line break in Excel Text to Columns?
In Excel for Microsoft 365 on Windows, choose Other as the delimiter and press Ctrl+J in its box. The character is invisible, so use the preview to confirm the split.

Is Ctrl+J a carriage return or a line feed?
For this Excel workflow, Ctrl+J enters a line-feed character, commonly represented by CHAR(10). A carriage return is CHAR(13), a distinct character.

Can Text to Columns split one cell into rows instead of columns?
No. Text to Columns places the pieces in adjacent columns. To arrange pieces vertically, use a suitable formula or another transformation method, then check that the output matches the intended row structure.

Why does Ctrl+J not work for my data?
The cell may contain wrapped text rather than a line-break character, or its source may use a different control character. Test on a copy and inspect the wizard preview; if needed, identify and normalize the source data first.

Will Text to Columns update when the original text changes?
No. It writes a one-time result. A formula such as TEXTSPLIT can recalculate from the source cell, provided your Excel version supports the function and the spill area is clear.

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.