Home > Microsoft Office > Excel > Separate Text - Excel
Separate Text - Excel
You can separate one column containing a lot of information into several columns so that it's easier to read or sort. A good example is a name column that contains both the last and first names in one column. You can separate the columns so that the first names appear in one column and the last names appear in another column. This article shows Excel 2016, but this process also works in Excel 2013 & 2010.
Step 1:Select the column you wish to separate.
Step 2:Click the Data tab. Under the Data Tools group, click Text to Columns.

|