Text to Columns

In this lesson you can learn how to separate the text written in one cell.

For this purpose one of the possibilities Excel is Text to Columns. This option is used to separate text, usually copied from another source such as the Internet. For this purpose I prepared a short example, where you’ll see how to use the Text to Columns.

Excel Text to Columns Table

Here are names separated by a comma stored in one cel. You and want to have them in two different columns. Text to Columns option is most often use to separate from each other by name. See how to do it.

How to separate from each other first and last name in Excel? It is very simple. Separating first and last name start with the selection of all cells.

Excel Text to Columns selected cells table

Then go to the Excel ribbon. On the Data section there is an interesting option Text to Columns.

Excel Text to Columns Ribbon button

When you choose Text to Columns Wizard appears in text-to-column. In the first step, select the type of data format that best describes the data source. In this case it is a type Delimited, because the first and last name are separated by a comma.

Excel Text to Columns Convert Text to Columns Wizard

In the second step, select the source text delimiters. In this case it is a comma. Immediately at the bottom of the dialog box you can see how Excel will allocate this text.

Text to Columns Convert Text to Columns Wizard

Skip the third step and leave everything as it is. Click Finish and verify results.

Excel Text to Columns Table name and vorname separated

In this way Excel simply separated from each other names. Now they are in two columns.

Template

You can download the Template here – Download
Previous articleExcel Object Linking: Data Integration
Next articleGoogle Classroom Tutorial: Empowering Educators