![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
Try it!
You can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard.
-
Select the cell or column that contains the text you want to split.
-
Select Data > Text to Columns.
-
In the Convert Text to Columns Wizard, select Delimited > Next.
-
Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
-
Select Next.
-
Select the Column data format or use what Excel chose for you.
-
Select the Destination, which is where you want the split data to appear on your worksheet.
-
Select Finish.
Want more?
Split text into different columns with the Convert Text to Columns Wizard