Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

To do this, first, select the cells in column A, and in the Data tab on the ribbon, click "Text To Columns." In the Convert Text to Columns Wizard, select "Delimited," and click "Next." ...

Step 1: You first select the column, and then click on Text to Columns in the Data menu. Mark Coppock/Digital Trends Step 2: Next, simply follow the same steps as used in splitting a cell. How to ...

Select the column in your Excel spreadsheet containing the full names you want to split. Go to the Data tab and click Text to Columns in the Data Tools group. Select Delimited and click Next.