Split cells

1. Select the cells you want to split and go to Data and choose  Text to Columns.

2. Select Delimited and then choose Next,

3. Choose the Delimiters that apply. Check the preview and then select Next. 

4. Choose the Column data format and select Finish.

Warning: If there is data in the cells to the right of the cells you're splitting, it may be overwritten.

1. Select the cells you want to split, go to the Data tab and choose  Text to Columns.

2. Select the Delimiters.

3. Check the preview and then select Apply. 

Warning: If there is data in the cells to the right of the cells you're splitting, it may be overwritten.