Excel: How to Parse Data (Split Column Into Two)

Excel: How to Parse Data (Split Column Into Two)

Excel 2010 and 2013 allow you to parse cells so that you can split data which is contained in one column (e.g., Column A: Last Name, First Name) between two columns (Column A: Last Name. Column B: First Name) without entering the data into each individual cell manually. After opening Excel and the data you would like to split, please follow the procedure below.

  1. Select the column that contains the combined data (e.g., Last Name, First Name) by clicking the letter directly above the column.
  2. Click the “Data” tab in the Office ribbon > Click “Text to Columns.” which is located in the "Data" group.
  3. The “Convert Text To Columns” wizard will display. Choose “Delimited.”
  4. Click “Next.”
  5. Select the delimiter within your data. A delimiter is the symbol or space which separates the data you wish to split. For example, if your column reads “Smith, John” you would select “Comma” as your delimiter. 
  6. Select “Treat consecutive delimiters as one.”
  7. Click “Next.”
  8. Under “Column data format” choose “General”
  9. Click the spreadsheet icon next to the "Destination:" text box.
  10. Now select the column where you wish the data to split and display.
  11. Click the spreadsheet icon once more to return to the wizard.
  12. Click “Finish.”

Keywords:  excel, parse, split columns, parse data, split cell

Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty