Shortcut keys
WindowsAlt → A → E
MacNo direct shortcut
Ribbon path
Data → Text to Columns
What it does
Split text in one column into multiple columns by a delimiter like comma, space, or tab. Essential for cleaning imported data.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for text to columns?
On Windows, use Alt → A → E. On Mac, use No direct shortcut.
Where is text to columns in the Excel Ribbon?
The Ribbon path is Data → Text to Columns.
What does text to columns do in Excel?
Split text in one column into multiple columns by a delimiter like comma, space, or tab. Essential for cleaning imported data.