Select the 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 split positions
Click Next
Choose the destination cells if needed
Click Finish
Select the 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 split positions
Click Next
Choose the destination cells if needed
Click Finish