Excel Text to Columns Shortcut Key for Windows and Mac

In Excel for Microsoft 365 on Windows, select a cell in the column you want to split, then press Alt, A, E in sequence to open the Text to Columns wizard. Choose a delimiter or fixed-width breaks, review the preview, and finish; on a Mac, use Data > Text to Columns because the Windows key sequence does not apply.

The Windows shortcut and what it opens

Alt, A, E is a ribbon Key Tip sequence, not a three-key combination to hold down at once. Press and release Alt, then press A to open the Data tab’s Key Tips, and press E to launch Text to Columns. In Excel, Key Tips are the letters or numbers shown on the ribbon after you invoke the Alt key.

The shortcut opens a wizard; it does not split the selected cells immediately. That distinction is useful because the wizard lets you choose how the values are divided and inspect the result before applying it. If your ribbon is customized, Excel is localized, or the shortcut letters differ in your installation, use the ribbon route instead: Data > Text to Columns.

How to run the Text to Columns wizard

Start with the source data in a single column. Click a cell in that column, or select the range you want to process, then open the wizard with the shortcut or ribbon. The wizard has three stages, and the choices you make affect how Excel interprets the data.

Choose a split method. Select Delimited if a character such as a comma or space marks each boundary. Select Fixed width if the values line up in consistent character positions.
Set boundaries. For delimited data, check the relevant delimiter and inspect the preview. For fixed-width data, add, move, or remove break lines in the preview.
Choose how the output is treated. In the final stage, you can set a column’s format, such as Text or Date, and change the destination cell. Check the preview before clicking Finish.

Text to Columns places the separated results across columns, starting at the destination. If you leave the destination at the source location, the first output column replaces the original values. The other output columns occupy cells to its right, so make sure those cells are empty or that you have deliberately chosen a safe destination.

Delimited or fixed width: which should you choose?

Delimited is the right choice when a repeated character separates fields. Common examples include commas in exported lists, tabs between copied fields, semicolons in some regional data, or spaces between words. The delimiter is a boundary marker: Excel removes it from the split result rather than keeping it as a separate column.

The wizard also offers an Other delimiter, which is useful for a consistent character such as a vertical bar in a text export. A checkbox can treat consecutive delimiters as one, which matters when repeated spaces or commas represent a single gap. The text qualifier setting handles characters—often quotation marks—that group text containing a delimiter. For example, a comma inside a quoted address should not necessarily split that address into two fields.

Fixed width is for records whose fields begin and end at consistent character positions, even when there is no delimiter. You set break lines in the preview to show where one output column ends and the next begins. It works well for aligned, fixed-format text, but is a poor fit when field lengths vary from row to row. In that case, use a delimiter or another parsing method.

Practical examples of splitting a column

Suppose column A contains values such as North,West, with one region pair per row. Choose Delimited, select comma, and check the preview. Excel will put the text before the comma in one column and the text after it in the next. If the source includes a space after each comma, the second result may begin with a space; choose the delimiter settings carefully and inspect the preview rather than assuming every file is formatted identically.

For a column of full names such as Jordan Lee, choosing a space delimiter splits at every space. That is suitable if every entry has exactly two parts, but it can create extra columns for names such as Jordan A. Lee or names with multiple spaces. Text to Columns follows the delimiter; it does not understand which word is a first, middle, or last name. Check a representative sample before applying a split to a large list.

For a fixed-width example, imagine a text report where every row stores a four-character code followed by a six-character quantity field. If those positions are consistent, choose Fixed width and place a break after the code. If one row contains a shorter code or a longer field, however, the same break may divide that row incorrectly. The preview is a practical way to spot this limitation before changing the worksheet.

Protect dates, identifiers, and existing data

The wizard’s format choices are important because Excel may interpret split results rather than preserve their appearance as plain text. A value such as 00127 can become the number 127 if Excel treats it as General. For postal codes, account references, product IDs, and other identifiers where leading zeros matter, select the relevant output column in the final wizard step and set its format to Text.

Dates can also be interpreted according to the computer’s regional settings. A string like 03/04/2026 can be ambiguous because some locales read it as March 4 and others as 3 April. If the source uses a known date order, use the date option in the wizard and choose the matching order when available. If you need to retain the original characters exactly, use Text instead and convert the values later under controlled conditions.

Before clicking Finish, check both the preview and the destination. Splitting into occupied cells can overwrite information, and formatting a column as General can change identifiers or date-like text. For important data, copy the source column to a spare area or make a workbook copy first. If the result is wrong, Ctrl+Z normally undoes the operation, but checking first is safer than relying on undo.

Windows, Mac, and Excel for the web

The stated shortcut is for Excel for Microsoft 365 on Windows. It uses Windows ribbon Key Tips, so do not assume Alt, A, E will open the same command on a Mac. On Excel for Mac, select the source column and choose Data > Text to Columns from the ribbon. The exact keyboard access available for ribbon commands can depend on the Mac version and settings; the menu route is the dependable option.

Excel for the web has a different interface and feature availability can vary. If Text to Columns is visible on the Data tab, follow the on-screen options. If it is not available in your version, open the workbook in the desktop app, where the wizard is available. When using a browser, also take care not to confuse Text to Columns with splitting text in another spreadsheet product; their menus and behaviors are not necessarily identical.

Alternatives when a wizard is not the best fit

Text to Columns is convenient for a one-time split of a column, but it changes worksheet cells into separate values. If the source data will be refreshed repeatedly, Power Query can be a better choice: it can split a column as a recorded transformation and repeat the steps when updated data is loaded. Its menus and availability depend on the Excel platform and build, but it is designed for repeatable data preparation rather than a single manual operation.

For formula-driven results that update when the source changes, Microsoft 365 and Excel 2024 include text functions such as TEXTSPLIT. In Microsoft 365, for example, a formula can split a text value using a chosen delimiter and spill the results into neighboring cells. That approach is dynamic, unlike Text to Columns, but requires a compatible Excel version and enough empty cells for the results. For a quick one-off cleanup, the wizard is often simpler; for recurring imports or formulas that must recalculate, consider Power Query or a suitable function.

Common problems and how to fix them

The shortcut does not open the wizard: press the keys in sequence, not simultaneously. If the Key Tips differ, use Data > Text to Columns or follow the letters displayed by your ribbon.
Everything stays in one column: confirm that you selected Delimited or Fixed width as appropriate and that the delimiter is actually present in the source values. Check the preview for a visible split.
Values lose leading zeros: go back and set the affected output column to Text before finishing. Formatting the cell as Text after zeros have already been dropped does not restore them.
Unexpected extra columns appear: the chosen delimiter may occur inside some entries, or spaces may be repeated. Review the text qualifier and consecutive-delimiter options and inspect unusual rows.
Results overwrite nearby information: cancel or undo if possible, then rerun the wizard with an empty destination range. Leave enough blank columns for the widest expected result.

Frequently Asked Questions

What is the Excel Text to Columns shortcut on Windows?
In Excel for Microsoft 365 on Windows, press Alt, A, E in sequence. It opens the wizard; you still need to choose the split settings and finish the operation.

Is Alt+A+E pressed at the same time?
No. It is a sequence of ribbon Key Tips: press and release Alt, press A, then press E. Key Tips can vary if Excel uses a different language or a customized ribbon, so the Data tab command is an alternative.

What is the Text to Columns shortcut on a Mac?
Use Data > Text to Columns in Excel for Mac. The Windows Alt-key sequence is not the Mac equivalent.

Can Text to Columns split text by spaces?
Yes. Choose Delimited and select Space. Because it splits at every space, check entries with middle names, multiword locations, or extra spaces before applying it to the full column.

How do I keep leading zeros when splitting?
In the wizard’s final step, select the output column containing the identifiers and choose Text as its column data format. This helps preserve values such as 00127 as text instead of converting them to the number 127.

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.