Excel Text to Columns Shortcut: Windows and Mac

In Excel for Microsoft 365 on Windows, press Alt+A, then E to open the Text to Columns wizard; press the keys in sequence, not together. Choose Delimited for separators such as commas or tabs, or Fixed width for columns aligned by position, then follow the wizard to split the selected data.

What Text to Columns does

Text to Columns takes the contents of one column and divides them into two or more columns. It is useful when a worksheet contains values that were combined into one field, such as a full name, a comma-separated address, or data copied from a report. The feature changes the worksheet cells; it does not merely change how text looks on screen.

For example, a cell containing Jordan Lee,Portland,OR can become three cells: Jordan Lee, Portland, and OR. You tell Excel how to identify the boundaries, either by selecting a delimiter character or by setting positions for fixed-width fields.

The command is on the ribbon at Data > Text to Columns. The shortcut opens the same wizard, so you can use the ribbon path if you prefer clicking or if the keyboard sequence behaves differently in your Excel setup.

How to use the Windows shortcut

Select the cells in the column you want to split. You can select a single cell in the data column, but selecting the relevant range makes it easier to check what will be affected.
Press Alt+A to activate the Data tab’s KeyTips, then press E to choose Text to Columns. KeyTips appear as letters or combinations on the ribbon after you press Alt.
In the wizard, choose Delimited or Fixed width, then select Next.
Set the separator or column breaks and inspect the preview. Adjust the settings until the preview shows the intended columns.
Choose Next if you want to assign formats to individual output columns, or select Finish to apply the split with the current settings.

KeyTips can vary with Excel’s language, ribbon customization, or version. If pressing Alt+A, E does not select the command, press Alt and look at the letters displayed over the ribbon controls, or open Data > Text to Columns directly. The shortcut uses the ribbon’s access-key sequence; it is not a single dedicated key combination.

Delimited data: choose the right separator

Choose Delimited when a consistent character or marker separates the pieces. In the wizard, Excel offers common choices such as Tab, semicolon, comma, and space, as well as an option to enter another character. The preview is especially important: a delimiter that appears harmless in one row may also occur inside a value in another row.

Comma: Useful for simple comma-separated values such as Portland,OR,97205, provided commas are not also part of the field contents.
Tab: Often appropriate for text copied from a table or report where fields are separated by tab characters.
Space: Can split text such as Jordan Lee, but it also splits at the space between first and last names. That may produce more columns than intended.
Other: Use a consistent symbol such as a pipe character in data like Jordan Lee|Portland|OR.

If repeated separators should count as one boundary, select Treat consecutive delimiters as one. For instance, if the text contains two spaces between fields, this option can prevent an unwanted empty column. Leave it off when consecutive delimiters represent genuinely empty fields, such as a missing value between two commas.

The Text qualifier setting helps with delimited files in which a character such as a quotation mark encloses a field. A comma inside a quoted field may be part of the value rather than a boundary. Check the wizard’s preview before finishing, particularly with exported or CSV-style data; the presence of commas alone does not guarantee that every comma should split a field.

Fixed-width data: split by position

Choose Fixed width when the fields occupy consistent positions rather than being separated by a character. The wizard displays a preview with proposed break lines. Click in the preview to add a break, drag a line to reposition it, or remove an unwanted break. For example, a report may place a three-character region code in the same character positions on every row.

This method works only when the positions are consistent across the selected records. If one row has a longer name that shifts the following values, a break based on character count may divide that row incorrectly. For irregular text, a delimiter or a more structured import method is usually a better fit.

Protect existing data and choose an output location

Text to Columns writes the separated results into cells on the worksheet. By default, the first output begins in the selected column, so additional pieces extend into columns to its right. If those cells already contain information, the results could overwrite it; Excel may warn you about occupied cells, but it is safer to check before proceeding.

Insert blank columns to the right of the source column if you need to preserve neighboring data.
Alternatively, set a different starting cell in the wizard’s Destination box, such as D2, so the output goes elsewhere.
Keep a copy of the original values if you may need to reverse the transformation. Undo can reverse a recent operation, but it is not a substitute for a saved copy when making substantial changes.

Destination matters when you select multiple rows: Excel places each row’s split values across the output columns beginning at the chosen cell. Make sure the destination range has enough room both horizontally for the resulting fields and vertically for all the selected records.

Set column formats to avoid changed values

Text to Columns can affect how Excel interprets the resulting values. In the wizard’s final step, you can select a column in the preview and assign a format such as General, Text, or Date. General is convenient for ordinary values, but Excel may interpret some strings as numbers or dates. Text is safer for identifiers that must retain their exact characters.

Consider a product code such as 00421. If Excel treats it as a number, the leading zeros may disappear. Assigning the output column a Text format preserves the code as text. Similarly, postal codes, account references, and long identification numbers are often labels, not quantities to calculate with.

Date interpretation deserves particular care. A string such as 03/04/2025 can mean different dates depending on the expected month-day order. If the source uses a known date order, select the relevant date format in the wizard rather than relying on a guess. Review the results after splitting, especially when the source data came from another country or system.

Common problems and how to fix them

Everything stays in one column: Confirm that the correct delimiter is selected and that it actually appears in the source values. If the data uses a tab or pipe rather than a comma, choose that character instead.
Values split into too many columns: The chosen separator may also occur inside a field. Check for a suitable text qualifier, select a more specific delimiter, or use fixed width if the field positions are reliable.
Unexpected empty columns appear: Look for repeated delimiters. Select Treat consecutive delimiters as one only if those repetitions should act as a single separator.
Leading zeros disappear or codes change: Select the relevant preview column and set its format to Text before finishing. General formatting can convert text that looks numeric into a number.
Neighboring cells are affected: Undo immediately if appropriate, then rerun the wizard with blank columns or a separate destination. Always check the destination area first.
Rows split inconsistently: The records may not share one reliable delimiter or fixed-width layout. Clean the source first, or use an import or formula approach designed for the data’s structure.

Excel for Mac and Excel for the web

In Excel for Mac, use Data > Text to Columns to open the wizard. The Windows sequence Alt+A, E is not the Mac equivalent, and there is no need to assume that the same ribbon KeyTips apply. Mac keyboard shortcuts can depend on the keyboard and Excel setup; the menu path is the dependable way to locate the command.

Excel for the web may not expose the same full Text to Columns workflow as the Windows desktop app. If the command is unavailable in your browser version, open the workbook in the desktop app and use the Data tab. Menu availability and features can change, so check the ribbon in the version you are using rather than relying on a Windows shortcut in a browser.

When to use an alternative

Text to Columns is a good choice for a one-time split or a quick cleanup. It is less suitable when new rows will arrive regularly and you need the same transformation to refresh repeatedly. In that case, consider importing and transforming the source with Power Query, or using a formula if the split needs to update whenever the original text changes.

In Excel for Microsoft 365 or Excel 2024, TEXTSPLIT can split a cell’s contents with a formula. With the text Jordan|Portland|OR in cell A2, enter =TEXTSPLIT(A2,"|") in B2. The result spills horizontally into B2:D2 as Jordan, Portland, and OR, provided those output cells are empty. Unlike Text to Columns, the formula result can update when A2 changes, but the formula requires a version that supports TEXTSPLIT.

For repeated imports, Power Query can retain a sequence of transformation steps and apply them again when data is refreshed. Its controls are more involved than the Text to Columns wizard, but that repeatability can be valuable when the same source format is processed regularly. For a single static cleanup, the shortcut and wizard are usually more direct.

Frequently Asked Questions

What is the shortcut for Text to Columns in Excel?
In Excel for Microsoft 365 on Windows, press Alt+A and then E. These are sequential ribbon KeyTips. If they do not match your setup, use Data > Text to Columns or check the KeyTips displayed after pressing Alt.

Is Alt+A, E one shortcut or two shortcuts?
It is a sequence of two key presses: Alt+A opens the Data tab’s KeyTips, and E selects Text to Columns. Do not hold Alt, A, and E down as one simultaneous combination.

How do I split a cell by a comma?
Select the source column, open Data > Text to Columns, choose Delimited, and select Comma. Check the preview, set the destination if needed, and finish. If commas occur inside quoted values, inspect the text qualifier and preview carefully.

Can Text to Columns split names into first and last names?
It can split on a space, but that may create extra columns for middle names, double-barrelled names, or suffixes. Use it only if the name format is consistent and the resulting split is what you want; otherwise, a more tailored cleanup may be necessary.

Does Text to Columns keep the original column?
By default, the results begin in the selected column, so the original contents are replaced by the first split part and the remaining parts go into columns to the right. Choose a different Destination or copy the source first if you need to retain the original values.

What is the Text to Columns shortcut on Mac?
Use Data > Text to Columns in Excel for Mac. The Windows Alt+A, E ribbon sequence should not be treated as a Mac shortcut; the menu path is the straightforward option.

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.