News

The Illinois Technology Foundation is a not-for-profit organization dedicated to the development of the technology talent pipeline in the State of Illinois.

Text to Columns Function in Excel

Have you ever had an Excel worksheet where full names were combined into one cell and you needed to have the first name in one cell and the last name in another cell? Well, did you know that you don’t have to copy, paste then delete or retype the names? You can use the Text to Columns function in Excel.

  1. Make sure you have an empty column to the right of the column that currently has the names in them.
  2. Select the range of data that you want to convert.
  3. On the Data tab, in the Data Tools group, click Text to Columns.
  4. In Step 1 of the Convert Text to Columns Wizard, click Delimited, and then click Next.
  5. In Step 2, select the Space check box, and then clear the other check boxes under Delimiters.
  6. The Data Preview box will show the first and last names in two separate columns.
  7. Click Next.
  8. In Step 3, click a column in the Data Preview box, and then click Text under Column Data Format.
  9. If you want to insert the separated content into the columns next to the full name, click the icon to the right of the Destination box, and then select the cell next to the first name in the list.
  10. Click the icon to the right of the Convert Text to Columns Wizard.
  11. Click Finish.

For more information, visit Directions Training at www.directionstraining.com or call toll free at 855-575-8900.

Illinois Technology Foundation Partner Sites
Student Tech Club
Center For Innovative Thinking