Select the cell or cells you want to split
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Click Next
Select the delimiter or set the column breaks
Click Next
Choose the destination cells if needed
Click Finish
Select the cell or cells you want to split
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Click Next
Select the delimiter or set the column breaks
Click Next
Choose the destination cells if needed
Click Finish