To separate text that’s in one column into many columns, use Text To Columns under the Data menu. This is often encountered when you copy data from another application. In this example, company names and addresses were copied into Excel. Because it doesn’t know any better, all the data is in one column, separated by commas, exactly as it was in the application is was copied from.
Select the column with the data, not the columns where you want the data to end up, and choose Text To Columns from the Data menu.
In the first dialog, you tell Excel whether the data is delimeted or fixed-width. Since this data is separated by commas, choose delimted.
Next, tell it which character is separating the text (commas in this case) and some special text handling stuff.
Finally, you have the option of telling Excel what kind of data is in each column. All of this data is simple text, so we’ll leave it set to General.
Click Finish, and with a little adjustment to the column widths, you can see the data separated into columns.