Whenever you have some text in one column and you wish to break it into several ones then instead of retyping the text in the next column, you can use the “Text to Columns” option under the “Data” tab. For e.g. Both the names and marks of the students are in the same column(say Column A) and you want to separate them in different columns as shown below:
The first step is to highlight the column that needs to be separated. Then click “Data” and choose “Text to Columns” option.
Then choose the delimited option.
Select the “space” check box, keeping others unchecked. So whatever text is after the space will be put into the next column.
As soon as you click the “Next” tab you will see the preview of your data. And you will notice that it has put marks into the next column.
Now just click the “Finish” button and it will be done.