Excel Text to Columns Shortcut: Windows and Mac

In Excel for Microsoft 365 on Windows, press Alt, then A, then E to open Text to Columns; press the keys one after another, not as a simultaneous chord. On a Mac, use Data > Text to Columns because there is no consistent built-in Mac shortcut equivalent to that Windows key sequence.

What the shortcut opens

Text to Columns is Excel’s tool for splitting the contents of one column into multiple columns. The Windows sequence Alt, A, E activates the command on the Data tab through Excel’s ribbon key tips. Tap Alt to display the key-tip letters, choose A for Data, and then E for Text to Columns. Depending on your Excel language, ribbon layout, or customized key tips, the letters can differ; the ribbon route is the dependable alternative: Data > Text to Columns.

The shortcut opens a three-step wizard rather than splitting the data immediately. You choose how Excel should identify the split points, check the preview, and then set how the resulting columns should be placed and interpreted. This matters because choosing the wrong delimiter or destination can create unwanted columns or replace data already in the worksheet.

Text to Columns is a command, not a formula. It changes worksheet cells into separate values, so it is useful for cleaning or reshaping a list that is already in the workbook. If you need a result that updates automatically when the source changes, a formula or Power Query may be a better fit.

How to split a column with the keyboard

Start with a copy of the workbook or make sure the original data is recoverable. Then follow these steps in Excel for Windows:

Select the cells containing the values to split. You can select a range in one column or click a cell in the list.
Press Alt, then A, then E. The Text to Columns wizard opens.
Choose Delimited if a character such as a comma, space, tab, or semicolon separates the fields. Choose Fixed width if the split positions are determined by consistent character positions.
Choose Next, set the delimiter or column breaks, and use the preview to inspect the result.
Choose Next again to set column formats and the destination, if needed.
Choose Finish to apply the split.

The selection is important: Excel uses it to decide which source values to process. If only one cell in a continuous list is selected, Excel may detect the surrounding data, but selecting the intended range makes the operation clearer and reduces the chance of splitting extra rows. A header can be included if you want its text split too; otherwise, select only the data rows.

Delimited or fixed width: choosing the split method

The right method depends on how the original text is structured. Delimited is the common choice when a consistent separator marks the boundary between fields. Fixed width is appropriate when fields occupy predictable character positions, even though there is no visible separator between them.

Delimited example: A1 contains Riley Chen,Seattle,WA. Choosing comma splits it into Riley Chen, Seattle, and WA in separate columns.
Tab-separated example: Data pasted from a report may already have tab characters between fields. Select Tab as the delimiter.
Fixed-width example: A text export might put a product code in characters 1–8 and a quantity starting at character 9 on every row. Add a break at that position and check the preview.

With Delimited selected, you can select more than one delimiter, such as comma and space. That can be useful, but it can also split a multiword value unexpectedly. For example, choosing both comma and space for a list containing Riley Chen, Seattle may separate the first and last name as well as the city. Use the preview to confirm each intended field stays together. The option to treat consecutive delimiters as one can help when repeated separators should not create empty fields, but leave it off if empty fields carry meaning in the source.

For Fixed width, Excel shows break markers in a preview. Add, move, or remove markers until the preview shows the desired columns. This method relies on the text lining up consistently from row to row; if one record has an extra character, later fields may land in the wrong columns. When rows vary in length, a delimiter or a more structured import method is usually safer.

Preview, formats, and destination: prevent surprises

Do not treat the wizard preview as decoration. It is the quickest way to spot a separator that breaks too often, a field that should remain together, or a fixed-width boundary in the wrong place. Check several representative rows, including ones with longer names, missing fields, or punctuation. If the sample is not representative, inspect the result on a duplicate sheet before applying it to the full list.

In the final step, Excel lets you assign a format to each output column. The default General format can convert text that looks like a number or date into a numeric value or date. Select a column in the preview and choose Text if characters such as leading zeros must be preserved. For instance, a postal code like 02139 can lose its first zero if Excel interprets it as a number. Choosing Text for that output column helps keep it as written.

Excel also provides date interpretation choices for date-like values. Select the format that matches the order in the source, such as month-day-year or day-month-year. A string such as 03/04/2026 is ambiguous without knowing the source convention: it could mean March 4 or April 3. Do not assume Excel can infer the intended meaning from the text alone.

Pay particular attention to Destination. Text to Columns writes the separated fields into cells, usually across the same row as the source. The default destination may overlap the selected source, and output can occupy neighboring columns. If those cells contain information, the split can replace it. To retain the original text, set Destination to an empty starting cell or copy the source to another worksheet first. Ensure there are enough blank columns to the right for every output field.

Examples that clarify common delimiter choices

Suppose a column contains INV-2048-SEA, where hyphens separate an invoice number, sequence, and location code. Select the data, open the wizard, choose Delimited, and use a hyphen as the delimiter. The preview should show three fields. If some codes contain hyphens internally, however, this method may split those codes too; the separator must be reliable throughout the data, not merely in one example.

For full names, splitting on a single space is not always equivalent to splitting into first and last name. A value such as Jordan Lee Morgan contains two spaces and could produce three pieces, while a compound surname or a middle initial creates further ambiguity. Text to Columns follows the delimiter you specify; it does not understand people’s names or decide which word belongs in which field. If the data needs semantic interpretation, check it manually or use a process designed around the actual naming rules.

For an address such as 18 Pine Road, Unit 4, Portland, OR, a comma may separate some fields, but the address itself may contain commas or inconsistent formatting. If you split on every comma, inspect whether the resulting pieces correspond to the columns you need. The tool performs a mechanical split, not address recognition.

Common problems and how to fix them

The shortcut does not open the wizard: Press Alt and watch the ribbon key tips. If the letters differ, follow the displayed tips, or click Data > Text to Columns. Keyboard layouts, localization, and custom ribbon settings can affect key-tip letters.
Everything remains in one column: Check that the chosen delimiter actually appears between fields. A tab-separated list will not split on commas. Confirm the preview changes when you select the delimiter.
Values split into too many columns: A selected separator may also appear inside a field. Remove unnecessary delimiters, reconsider whether consecutive delimiters should count separately, and inspect the preview before finishing.
Leading zeros disappear or dates change: Excel may have converted the values under General formatting. In the wizard’s final step, choose Text for identifiers that must remain unchanged, or choose the correct date order for date values.
Nearby data is replaced: The output has been written into occupied cells. Undo immediately with Ctrl+Z if you have not made other changes, then rerun the wizard with a blank destination or on a copy. Avoid relying on undo after a chain of later edits.
Blank fields appear between results: Repeated separators may be treated as separate delimiters. Use the consecutive-delimiters option only when adjacent separators should act like one; otherwise, the empty result may correctly reflect the source.

Text to Columns is a cell-editing operation, not a live connection. Once applied, changing the original source text does not automatically recompute the separated output. If the source is likely to change, keep a clean source column and use a repeatable transformation method, or rerun the operation after the data changes.

Windows, Mac, and Excel for the web

For Excel for Microsoft 365 on Windows, the commonly used ribbon sequence is Alt, A, E. Press each key in sequence. If your installation shows different key tips, use the labels Excel displays after you press Alt rather than assuming every language or customized ribbon uses the same letters. You can also reach the command with the mouse through Data > Text to Columns.

In Excel for Mac, use Data > Text to Columns from the menu or ribbon. Mac keyboard commands use a different system, and the Windows Alt-key sequence should not be treated as a Mac shortcut. Excel for the web has a different interface and feature availability can vary; if the command is not present in your current web interface, open the workbook in the desktop app and use its Data tab. Keep a copy before making a large-scale transformation in any version.

When to use another Excel tool

Text to Columns is a good choice for a one-time split where the separator or character positions are stable. It is not always the best option for repeat imports, variable patterns, or data that must stay synchronized with its source.

Use Flash Fill when you want Excel to recognize a pattern from examples, such as extracting a first name from a list. Review the generated results because Flash Fill infers a pattern rather than applying an explicit delimiter rule.
Use formulas when the result should update as source cells change. A formula-based approach can be more transparent for a recurring worksheet, but the appropriate formula depends on the Excel version and the structure of the text.
Use Power Query for repeatable imports and transformations, especially when the same cleanup must be performed again on refreshed data. It offers a recorded sequence of transformation steps rather than a one-off cell split.

These alternatives solve related but different problems. Text to Columns is direct and easy to inspect for a straightforward list. A formula maintains a calculated relationship, while Power Query is designed for repeatable data preparation. Choose based on whether the split is a one-time change, needs to update, or will be repeated as part of an import workflow.

Frequently Asked Questions

What is the keyboard shortcut for Text to Columns in Excel?

In Excel for Microsoft 365 on Windows, press Alt, then A, then E. It is a sequence of key-tip presses, not a shortcut where all three keys are held down together. If the sequence differs on your installation, use the key tips shown after pressing Alt or choose Data > Text to Columns.

Can I use Text to Columns on a Mac?

Yes. In Excel for Mac, open Data > Text to Columns. The Windows Alt, A, E key-tip sequence is not a Mac shortcut, and there is no consistent built-in Mac equivalent to recommend across installations.

Does Text to Columns delete the original data?

It writes the split results into worksheet cells and may overwrite the source or neighboring cells if the destination overlaps them. To preserve the original, choose an empty destination in the wizard or copy the source data to another location before splitting.

How do I split text without losing leading zeros?

In the wizard’s final step, select the output column in the preview and set its column data format to Text before choosing Finish. This is useful for postal codes, product IDs, and other values that look numeric but should remain text.

Why does Excel split my data at the wrong place?

The selected delimiter may also occur inside a field, or the source may not follow a consistent pattern. Review the preview, remove unwanted delimiters, and check multiple rows. If the split depends on position, try Fixed width; if the structure varies, consider Power Query or a carefully reviewed formula instead.

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.