Split text into different columns with Convert Text to Columns

Below are instructions for splitting text in one or more cells in Excel and spreading it out across multiple cells. The most common use case for this is when you have a recipient list with a single column of full names, but you need to separate first and last name into two columns.

Screen_Shot_2017-12-12_at_10.12.16_AM.png

 

1. Select the cell or column that contains the text you want to split.

2. Click Data >Text to Columns.

text_to_columns.png

3. This starts the Convert Text to Columns Wizard. Click Delimited > Next.

delimimted.png

4. 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.

 step_2.png

5. Click Next.

6. Under Column data format, check General and clear the rest of the boxes. Click Finish.

column_data.png

7. Your workbook will automatically update with the text in two separate columns. If you already have data in the column directly to the right of your original column, you'll want to insert a blank column next to your original column before applying the Text to Column.

Screen_Shot_2017-12-12_at_10.33.16_AM.png

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk