Home - Information Services - Get Help - How-to-Guides - Excel 2016 - Split Text into Columns

Split Text into Columns

1. Insert a new column to the right of the column that you want to split. (To insert the column, right-click the letter of the column to the right of the column that you want to split and select Insert.)
   
2. Select/highlight the column that you want to split.
   
   
   
3. On the Data tab, click Text to Columns.
   
   
4. Under Original data type, make sure Delimited is selected.
   
   
5. Click Next.
6. Select the correct delimiter for the data.
   
   
7. Click Next.
8. Click Finish.