Do you wish to break up a single column of textual content into a number of columns in your Excel spreadsheet? Utilizing the Textual content to Column function, you possibly can select the best way to break up the column up, repair the width, or break up at every comma, interval, or different character.
What’s the keyboard shortcut for Textual content to Column?
Mixture keys are using a number of keys pressed collectively to present a particular outcome. To open Textual content to columns simply, press the shortcut keys ALT+A+E.
Tips on how to convert Textual content to Columns in Excel
Observe the steps beneath to transform textual content to columns in Excel:
- Launch Excel.
- Enter some information right into a single cell, for instance, the primary identify and final identify of individuals.
- Spotlight the cell that you simply wish to break up.
- On the Information tab; Click on the Textual content to Columns button.
- A Convert Textual content to Columns Wizard dialog field will open.
- Choose Delimited, then click on Subsequent.
- Choose the Delimiters in your information; On this tutorial, we chosen House.
- Click on Subsequent.
- Select Normal as the information format.
- Click on End.
Launch Excel.
Enter some information right into a single cell, for instance, the primary identify and final identify of individuals.
Spotlight the cells that you simply wish to break up
On the Information tab; click on the Textual content to Columns button.
A Convert Textual content to Columns Wizard dialog field will open.
Choose Delimited, then click on Subsequent.
Choose the Delimiters in your information; On this tutorial, we chosen House.
Click on Subsequent.
Select Normal as the information format.
Click on End.
The textual content is break up into two columns.
What’s the function of the Convert Textual content to Columns Wizard?
The aim of the Convert Textual content to columns wizard is to separate the content material of 1 excel cell into separate cells. You possibly can set the delimiters that your information comprise and set the column information format.
We hope this tutorial helps you perceive the best way to convert textual content to columns in Excel; if in case you have questions in regards to the tutorial, tell us within the feedback.
Now learn: Tips on how to make the most effective use of Title Field in Excel.
