Excel: Split Text using text to columns wizard

https://www.youtube.com/watch?v=QBaSY8hhThg

Depending on your data, you can split the cell content based on a delimiter, such as a space, semicolon, tab, comma, etc or based on a specific column break location within your data. If the delimiters used by you is not an option in the wizard then user other and type the delimiter.

1. Select the range of data that you want to convert, make sure you dont select headings.


2. On the Data tab, in the Data Tools group, click Text to Columns.


3. In Step 1 of the Convert Text to Columns Wizard, click Delimited, and then click Next.


4. In Step 2, select the  delimiter which applies to you.


5. 
   
   
   
   1. Click Next.
   
   
   2. In Step 3, click a column in the Data preview box, and then click Text under Column data format.Repeat this step for each column in the Data preview box.
   
   
   3. If you want to insert the separated content into the columns next to the data you have , click the icon to the right of theDestination box, and then select the cell next to the first name in the list
   
   
   4. IMPORTANT: If you do not specify a new destination for the new columns, the split data will replace the original data. It is advisable to specify new destination columns when you are trying for the first time or always remember undo or CTRL Z to undo previous action.
   
   
   5. Click Finish.