Would you like to break up a single column of textual content into a number of columns in your Excel spreadsheet? Utilizing the Text to Column characteristic, you’ll be able to select how 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 Text to Column?
Mixture keys are the usage of a number of keys pressed collectively to give a particular outcome. To open Text to columns simply, press the shortcut keys ALT+A+E.
How to convert Text to Columns in Excel
Observe the steps under to convert textual content to columns in Excel:
- Launch Excel.
- Enter some knowledge right into a single cell, for instance, the primary identify and final identify of individuals.
- Spotlight the cell that you really want to break up.
- On the Information tab; Click on the Text to Columns button.
- A Convert Text to Columns Wizard dialog field will open.
- Choose Delimited, then click on Subsequent.
- Choose the Delimiters to your knowledge; On this tutorial, we chosen Area.
- Click on Subsequent.
- Select Normal as the info format.
- Click on End.
Launch Excel.
Enter some knowledge right into a single cell, for instance, the primary identify and final identify of individuals.
Spotlight the cells that you really want to break up
On the Information tab; click on the Text to Columns button.
A Convert Text to Columns Wizard dialog field will open.
Choose Delimited, then click on Subsequent.
Choose the Delimiters to your knowledge; On this tutorial, we chosen Area.
Click on Subsequent.
Select Normal as the info format.
Click on End.
The textual content is break up into two columns.
What’s the function of the Convert Text to Columns Wizard?
The aim of the Convert Text to columns wizard is to separate the content material of 1 excel cell into separate cells. You may set the delimiters that your knowledge include and set the column knowledge format.
We hope this tutorial helps you perceive how to convert textual content to columns in Excel; you probably have questions in regards to the tutorial, tell us in the feedback.
Now learn: How to make the most effective use of Title Field in Excel.
