Do you want to split a single column of text into multiple columns in your Excel spreadsheet? Using the Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other character.
What is the keyboard shortcut for Text to Column?
Combination keys are the use of one or more keys pressed together to give a specific result. To open Text to columns easily, press the shortcut keys ALT+A+E.
How to convert Text to Columns in Excel
Follow the steps below to convert text to columns in Excel:
- Launch Excel.
- Enter some data into a single cell, for example, the first name and last name of people.
- Highlight the cell that you want to split.
- On the Data tab; Click the Text to Columns button.
- A Convert Text to Columns Wizard dialog box will open.
- Select Delimited, then click Next.
- Select the Delimiters for your data; In this tutorial, we selected Space.
- Click Next.
- Choose General as the data format.
- Click Finish.
Launch Excel.
Enter some data into a single cell, for example, the first name and last name of people.
Highlight the cells that you want to split
On the Data tab; click the Text to Columns button.
A Convert Text to Columns Wizard dialog box will open.
Select Delimited, then click Next.
Select the Delimiters for your data; In this tutorial, we selected Space.
Click Next.
Choose General as the data format.
Click Finish.
The text is split into two columns.
What is the purpose of the Convert Text to Columns Wizard?
The purpose of the Convert Text to columns wizard is to separate the content of one excel cell into separate cells. You can set the delimiters that your data contain and set the column data format.
We hope this tutorial helps you understand how to convert text to columns in Excel; if you have questions about the tutorial, let us know in the comments.
