Use the Split Text to Columns feature
Select the cell or column
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Select the separator or set the split position
Click Finish
Use formulas like LEFT, RIGHT, and MID for manual splitting
Use Flash Fill to split patterns automatically
Insert a new column if needed to place the split data
Use CONCAT or TEXTJOIN to combine split parts later