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 you want, such as comma, tab, semicolon, space, or Other
If needed, type a custom delimiter in the Other box
Preview the split data
Click Next or Finish to apply the delimiter
Use Flash Fill or formulas if you need to separate data in a different way
Use Find and Replace to change one delimiter to another before splitting if needed