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

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

Excel 2010, 2013, and 2016 allow you to parse cells so that you can split data that 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, then look under the "Data Tools" group and click “Text to Columns.” The “Convert Text To Columns” wizard will appear. 
  3. Choose “Delimited”click "Next."
  4. 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. 
  5. Select “Treat consecutive delimiters as one.”
  6. Click “Next.”
  7. Under “Column data format” choose “General.”
  8. Click the spreadsheet icon next to the "Destination" text box.
  9. Select the column where you wish the data to split and display.
  10. Click the spreadsheet icon once more to return to the wizard.
  11. Click “Finish.”

Keywords:  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