Split text into different columns with the Convert Text to Columns Wizard

You can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard.

Applies to: Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.

https://www.microsoft.com/en-us/videoplayer/embed/RWfyHM?pid=ocpVideo0-innerdiv-oneplayer&postJsllMsg=true&maskLevel=20&market=en-us

1. Choose the cell or column that holds the text you want to split.

2. Click Data > Text to Columns.

3. In the Convert Text to Columns Wizard, press Delimited > Next.

4. Pick the Delimiters for your data. For example, Comma and Space. You can look at a preview of your data in the Data preview window.

5. Click Next.

6. Decide the Column data format or use what Excel selected for you.

7. Click the Destination, which refers to where you want the split data to display on your worksheet.

8. Press Finish.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Split text into different columns with functions