Select the cell or range of cells
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 cell if needed
Click Finish
Use Flash Fill for pattern-based separation
Use formulas like LEFT, RIGHT, MID, FIND, and LEN
Use Split Text to Columns in Google Sheets if needed
Use Power Query for advanced splitting