Dividing Text in Excel

Application: Microsoft Excel 2007 & 2010


Have you ever needed to separate last name and first names in an excel spreadsheet? There are frequently times when spreadsheet data needs to be divided into more granular information in order to better sort, filter, alphabetize, or use in a mail merge independently.
Spreadsheets can be updated with Excel’s Text to Column command that can divide the data into separate columns.


Divide data in one column
*These steps apply to data where a space is used to divide. For data that is divided by commas or other, please see the article listed below.
1. Insert a column(s) where the divided data will be placed.
2. On the Data ribbon, select Text to Columns.
3. The Text to Columns Wizard will appear. In Step 1, select Delimited.
4. Click Next. In Step 2, select Space. Be sure to uncheck all other options.
5. Click Next. In Step 3, select Text.
6. Click Finish.

             

        becomes

For more information about this feature, please visit the Microsoft Office article.