A way to split cells into different columns
- Select the cell or column that contains the text you want to split.
- Click Data >Text to Columns.
- This starts the Convert Text to Columns Wizard. Click Delimited > Next.
- Check Space, and clear the rest of the boxes, or check Comma and Space if that is how your text is split (Smith, John, with a comma and space between the names). You can see a preview of your data in the Data preview window.
- Click Next.
- In this step, you pick the format for your new columns, or you can let Excel do it for you. If you want to pick your own format, select the format you want, such as Text, click the second column of data in the Data preview window, and click the same format again. Repeat for all the columns in the previewwindow.
- Click the
button to the right of the Destination box to collapse the dialog box. - Select the cells in your workbook where you want to paste your split data. For example, if you are dividing a full name into a first name column and a last name column, select the appropriate number of cells in two adjacent columns.
- Click Finish.
