Select the data range
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Click Next
Select the delimiter or set column breaks
Click Next
Choose the destination cells
Click Finish
Use Flash Fill for pattern-based splitting
Use formulas like LEFT, RIGHT, MID, FIND, and LEN
Use Split Text to Columns in Excel for web if available
Use Power Query to split columns by delimiter
Use CONCATENATE or TEXTJOIN to recombine if needed