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.
Step 4:Choose Delimited and then click Next.
Step 5:Check the delimiter that is separating the text, then click Next.

Note: The delimiter is the character (a tab, semicolon, comma, space, or other character) that is separating the information that will be put into different columns. In this example, the delimiter is the comma separating the last name from the first name.
Step 6:Click Finish.
Step 7:What was once in one column will now be separated into two columns.  You can adjust the width of the new column as needed.

Related Articles