In case your information in Microsoft Excel is poorly structured and accommodated in a single column, you may split it into multiple columns. This put up presents easy-to-understand directions on how to split one single column into multiple columns in Excel.
Split one column into multiple columns in Excel
To split one column into multiple columns in Excel, comply with these steps:
- Change to the Information tab.
- Click on on the Textual content to Columns possibility.
- Select the Delimited possibility and click on the Subsequent button.
- Choose the delimiters and click on the Subsequent button.
- Select Common because the Column information format.
- Click on the End button.
To be taught extra about these steps, proceed studying.
1] Use Convert Textual content to Columns Wizard
You’ll be able to take the textual content in one column and split it into multiple columns utilizing the Convert Textual content to Columns Wizard. To get began, open the Excel Sheet in which you want to to split a single column into multiple columns.
Then, go to the ‘Data’ tab and choose the ‘Text to Columns’ part.
Subsequent, in the ‘Convert Text to Columns’ Wizard that reveals up in your display screen, choose the Delimited radio button and click on ‘Next’ to proceed.
2] Select Delimiters on your information
Right here, specify the Delimiters on your information. For instance, Comma and Area.
By default, Excel will try to separate your single-column information by every tab it finds. That is superb, however you may configure column information format by,
Common converts numeric values to numbers, date values to dates and all remaining values to textual content. Right here, we’re utilizing information that’s separated by semicolons.
If obligatory, you may see a preview of your information by switching to the ‘Data preview’ window and hitting the ‘Next’ button.
3] Select a vacation spot
Choose the ‘Column data format’ or use what Excel selected for you.
Lastly, specify the ‘Destination’ the place you want to the split information to seem in your worksheet.
When achieved, hit ‘Finish’.
As you may see in the picture above, the one column shall be split into multiple (2 columns) and the info will seem properly structured and arranged.
Learn: How to split Textual content to Columns in Excel and Google Sheets
How do you separate one column information into a number of columns in Excel?
To separate one column information into a number of columns in Excel, you want to use the Textual content to Columns function, which resides in the Information tab. Then, select the Delimited possibility and choose the Delimiters as per your necessities. On your data, you want to select the delimiter because the character used in the spreadsheet to separate the info. For instance, you probably have a comma, you want to choose a comma. Equally, you probably have a semicolon, you have to choose a semicolon. Lastly, select the info format and click on the End button.
How do I split one column into multiple columns in Excel with out delimiter?
In case your spreadsheet’s textual content doesn’t have a delimiter, it’s nonetheless doable to split one column into multiple columns in Excel. In that case, you want to use the Mounted width possibility as a substitute of Delimited. If you use the Mounted width possibility, Excel splits each phrase and creates a brand new column for it. Having mentioned that, you probably have a textual content known as That is pattern textual content, yow will discover 4 columns after utilizing the Mounted width possibility in the Textual content to Columns menu.
Learn: How to Freeze and Split Panes in Excel worksheets
