Select the cells or column you want to split
Go to the Data tab
Click Text to Columns
Choose Delimited
Click Next
Select the delimiter type such as comma, tab, semicolon, space, or Other
If needed, enter a custom delimiter in Other
Preview the split data
Click Next
Choose the destination cell if needed
Click Finish