Take text in one or more cells and split it into multiple cells using the Convert Text to Columns Wizard.
Try it!
-
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 Destination in your worksheet which is where you want the split data to appear.
-
Select Finish.
