How to separate information in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-separate-information-in-Excel.png)
Excel has several tools and functions that can be used to manipulate data. These prove useful when you are cleaning data or consolidating data from multiple sources. When working with a dataset you may find that you need to separate the information in a single column into multiple columns. In this example, we are going to separate the manufacturer and model of the car from the column.
Step 1 – Open the Convert Text to Columns Wizard
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-separate-information-in-Excel.png)
– Select the data
– Go to Data > Data Tools
– Click on Text to Columns
Step 2 – Choose the file type
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-separate-information-in-Excel.png)
– Select the Fixed width option
– Click on Next
Step 3 – Check the preview
![](https://spreadcheaters.com/wp-content/uploads/Step-3-–-How-to-separate-information-in-Excel.png)
– Check that the data has been separated correctly in the Data preview
– Click Next
Step 4 – Choose the format and destination
![](https://spreadcheaters.com/wp-content/uploads/Step-4-–-How-to-separate-information-in-Excel.png)
– Under Column data format, choose General
– Select the Destination for the data
– Click Finish
Step 5 – Sort the remaining data
![](https://spreadcheaters.com/wp-content/uploads/Step-5-–-How-to-separate-information-in-Excel.png)
– The manufacturer’s name is separated from the rest of the data
– Select the column with the rest of the data
– Go to Data > Sort & Filter
– Click on the Sort A to Z button
– In the Sort warning box select Continue with the current selection
– Click Sort
Step 6 – Select the next set of data
![](https://spreadcheaters.com/wp-content/uploads/Step-6-–-How-to-separate-information-in-Excel.png)
– Select the next set of data that can be separated based on a space delimiter
– Go to Data > Data Tools
– Click on Text to Columns
Step 7 – Choose the file type
![](https://spreadcheaters.com/wp-content/uploads/Step-7-–-How-to-separate-information-in-Excel.png)
– Select the Delimited option
– Click on Next
Step 8 – Choose the delimiter
![](https://spreadcheaters.com/wp-content/uploads/Step-8-–-How-to-separate-information-in-Excel.png)
– Choose Space as the delimiter
– Check that the data has been separated correctly in the Data preview
– Click Finish
Step 9 – Separate the rest of the data
![](https://spreadcheaters.com/wp-content/uploads/Step-9-–-How-to-separate-information-in-Excel.png)
– Separate the rest of the column using the Text to Columns wizard with either the Delimited or Fixed width option
– Delete the unwanted columns