Split the content from one cell into two or more cells
Select the cell or cells whose contents you want to split. ...
On the Data tab, in the Data Tools group, click Text to Columns. ...
Choose Delimited if it is not already selected, and then click Next.