Split Cells in Excel: Shortcut Key and Text to Columns

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the cell or column containing the text, then press Alt, A, E in sequence to open Text to Columns. Choose a delimiter, check the preview, and select Finish to place the pieces in separate cells. Excel does not have a single shortcut that divides a cell into smaller cells; this shortcut separates the cell’s contents into neighboring columns. Make sure those destination cells are empty before you finish.

The steps below cover the common case: separating text such as a full name, a list, or a comma-separated address. If you mean dividing a cell’s appearance or undoing a merge, see the notes in the steps and troubleshooting sections.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or another desktop version of Excel with the Text to Columns command.
  • A worksheet containing the text you want to separate. Keep a copy of the original data if the separation is important; Text to Columns can replace values in cells to the right.
  • At least one blank destination column for each additional piece you expect to create. For example, splitting one field into three parts requires room for the two extra results.
  • A clear idea of the separator in the text, such as a comma, space, tab, semicolon, or a consistent character sequence.

Step-by-Step

  1. Check what kind of split you need. Text to Columns divides the contents of a cell or column and writes the results into separate cells in the same row. It does not cut one worksheet cell into smaller cells, as a table editor might. For example, it can turn a cell containing Riley Chen into Riley in one column and Chen in the next. If you only want to make a visual division, use separate worksheet columns or rows instead.

  2. Prepare the source and destination cells. Save a copy of the workbook or duplicate the source column before changing valuable data. Look at the cells immediately to the right of your source. If they contain information, insert enough blank columns first: select the appropriate column headers, right-click, and choose Insert. Text to Columns can overwrite existing entries in its output area, so do not rely on an alert to protect them. If the source is part of an Excel table, consider converting the results or working in a blank area outside the table.

  3. Select the text to split. Click a cell in the column if you want to process that column, or select the specific range of rows you want to change. The selected cells should contain the same general kind of data and use a consistent separator. Avoid selecting unrelated columns. If you select only one cell, Excel may still identify the surrounding contiguous data; check the wizard’s preview and selection before proceeding.

  4. Open Text to Columns with the keyboard. On Windows, press and release Alt, then press A, then E. These are sequential ribbon KeyTips, not three keys that must be held down together. In English-language Microsoft 365 for Windows, this opens the Convert Text to Columns Wizard. If the letter sequence does not work in your language or Excel build, press Alt to display the KeyTips and follow the letters shown above the Data tab and Text to Columns command. You can also use the ribbon path Data > Text to Columns.

  5. Choose the splitting method. In wizard Step 1, select Delimited when a character such as a comma or space marks each boundary. This is the right choice for text such as Riley,Chen or North East. Choose Fixed width only when the values line up at consistent character positions, such as records padded with spaces to the same layout. Click Next.

  6. Set the delimiter and inspect the preview. In Step 2, select the delimiter that actually appears between the pieces: Tab, Semicolon, Comma, Space, or Other. For Other, type the separating character in the small field. If the text uses a repeated group of spaces as one separator, select Treat consecutive delimiters as one; leave it unchecked if each repeated delimiter should create an empty field. Use the preview to confirm that the dividing lines fall in the right places. For comma-separated text with values that contain commas inside quotation marks, check that the text qualifier is set appropriately, usually to the double-quote character. Otherwise, a comma inside a quoted value may cause an unwanted split. Click Next when the preview looks right.

  7. Choose the output format and destination. In Step 3, the General format is suitable for ordinary text and numbers, but Excel may interpret values such as dates or codes with leading zeros. Select the relevant output column in the preview and choose Text if you need to preserve an entry such as 00417 as text, or choose Date and the correct order if the source dates have a known format. In Destination, enter the first cell where results should go, such as $B$2, if you want to preserve the original data in column A. If you leave the default destination, Excel writes the results over the source column and into the columns to its right. Confirm that the destination area is clear.

  8. Finish and verify the result. Click Finish. Check several rows, including the first and last, to confirm that each part landed in the intended column and that numbers, dates, and leading zeros look correct. If the output is wrong, press Ctrl+Z immediately to undo the operation, then reopen the wizard and adjust the delimiter, format, or destination. Do not continue editing before undoing, because that can make it harder to restore the previous state.

On Excel for Mac, use Data > Text to Columns and follow the same wizard; the Windows Alt, A, E KeyTips are not the Mac shortcut. Ribbon keyboard shortcuts can vary by Mac keyboard and Excel version, so the menu command is the dependable route. Excel for the web may have a different command layout or feature availability; if Text to Columns is not available in your browser version, open the workbook in the desktop app.

Common Mistakes

  • Expecting the shortcut to split a cell visually. Text to Columns separates text values across cells; it does not split a worksheet grid cell into two independently sized cells. To create two fields, use adjacent worksheet columns. To reverse a merged area, select it and use Home > Merge & Center > Unmerge Cells. Unmerging does not divide the original value into pieces.

  • Choosing the wrong delimiter. Selecting Space for a person’s full name will split every space, so a three-part name may become three columns. Selecting Comma for data that uses semicolons will leave the text unchanged. Base the choice on the actual characters between fields and verify it in the preview.

  • Overwriting neighboring information. If a split produces several fields, Excel fills cells to the right of the output destination. Clear that area, insert blank columns, or choose a new destination before clicking Finish. A blank cell in the first row is not enough if lower rows already contain data.

  • Letting Excel convert identifiers. Codes like 0008 can become 8, and some long number-like strings may be reformatted. Set the relevant output column to Text in Step 3 when the characters must be preserved exactly.

  • Assuming every row has the same structure. A delimiter may occur a different number of times in different rows, producing blanks or extra fields. Review the preview and sample the results down the column before using them in reports or imports.

Tips

  • Use a safe destination when you are unsure. Point the wizard at a blank area or a new worksheet to preserve the original column. Once you have checked the output, you can decide whether to keep both versions or replace the source.

  • Use Fixed width for position-based records. In the wizard, choose Fixed width and click the preview ruler to add a break line; drag a line to adjust it or double-click one to remove it. This suits records where each field always occupies the same character positions, not text with variable-length words.

  • Use a formula for a live split. If the source text may change and you have Microsoft 365 or Excel 2024, TEXTSPLIT can return results that update with the source. With the value North,East in A2 and a comma as the separator, enter =TEXTSPLIT(A2,CHAR(44)) in B2; the result spills into B2 and C2 as North and East. Ensure the spill area is empty. Unlike Text to Columns, a formula-based result remains linked to A2.

  • Do not use Text to Columns as a recurring import workflow without checking. For a one-time cleanup, the wizard is direct. If you repeatedly receive files with the same layout, consider importing them through Excel’s data tools and confirming the column types during import. That can make it easier to repeat the process consistently.

  • Keep the original formatting in mind. Text to Columns may apply or change number formats as it interprets data. If formatting matters, test a few rows or use a copy of the source. A displayed date can also have a different underlying value from the text originally typed.

Troubleshooting

  • Alt, A, E does nothing. Make sure you are pressing the keys one at a time, and confirm that the workbook is active rather than a dialog or another app. KeyTips can vary with Excel’s language and version. Press Alt and read the letters currently displayed, or open Data > Text to Columns with the mouse.

  • The text stays in one column. Reopen the wizard and check whether the delimiter is selected and whether it matches the source exactly. If the separator is a character not listed, choose Other and enter it. For values separated by a fixed number of characters rather than a symbol, try Fixed width.

  • Parts appear in the wrong columns or are missing. Undo, then inspect the preview. Check for more than one delimiter, consecutive delimiters, spaces before or after values, and punctuation inside quoted text. Change the text qualifier or the Treat consecutive delimiters as one setting as needed. Test on a small copied range if the pattern is inconsistent.

  • Existing values disappeared. If you have not made other changes, press Ctrl+Z right away. Then rerun the wizard with a blank destination or insert enough columns before splitting. If undo is no longer available, restore the saved copy or use your organization’s file version history if it is enabled.

  • Leading zeros or dates changed. Undo the split and repeat it. In Step 3, select the affected output column and set its format to Text to preserve literal codes, or choose Date and the correct date order for dates. Applying Text formatting after Excel has already removed zeros will not restore the missing characters; you need to undo and split again from the original text.

  • The result is blocked or will not fit. Clear the cells in the intended output range, including cells farther to the right, or choose another destination. If the source is a merged cell, unmerge it first and make sure the data is in a regular worksheet range before using the wizard.

Frequently Asked Questions

What is the shortcut key to split cells in Excel?

For Text to Columns in English-language Excel for Microsoft 365 on Windows, press Alt, A, E in sequence. It is a ribbon KeyTip sequence for splitting text into columns, not a universal shortcut for dividing a cell’s grid space.

Can I split one Excel cell into two smaller cells?

No. Excel’s worksheet grid does not let you subdivide a single cell independently. Insert an adjacent column or row and place the separate values there. Text to Columns is for separating the contents of a cell.

Will Text to Columns change my original data?

It can. By default, the output starts in the selected source column and may replace the original text while filling cells to the right. Choose a blank Destination in Step 3 to keep the source unchanged.

Can I undo a split?

Usually, press Ctrl+Z immediately after finishing to reverse it on Windows. On Mac, use Command+Z. If you have made more edits since the split, undo may also remove those edits, so a saved copy is the safest backup.

Does the same shortcut work in Excel for Mac?

The Windows Alt, A, E sequence is not the Mac equivalent. On Mac, open Data > Text to Columns and use the wizard. Keyboard access and ribbon KeyTips can differ with the Mac version and keyboard settings.

Can I split text into rows instead of columns?

Text to Columns writes its results across columns. If you need values arranged vertically, first split the text into columns, then copy the results and use Paste Special > Transpose, checking the destination before pasting. For a repeatable or complex transformation, Power Query may be a better fit.

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.