Select the cell or cells you want to split
Go to the Data tab
Click Text to Columns
Choose Delimited or Fixed width
Click Next
Select the delimiter or set the split position
Click Next
Choose the destination cells if needed
Click Finish
For merged cells, use Unmerge Cells first if necessary
For splitting cell contents into multiple rows, use Power Query or formulas