To do this, go to the View tab in your Excel workbook and click the Split button. This will divide your current worksheet ...

To split the cells ... arrow next to the Merge and Center button and select Unmerge Cells. Merging cells is often confused with combining cells in Excel. Merging creates one cell by joining ...

You can take the text in one column and split it into multiple ... window and hitting the ‘Next’ button. Select the ‘Column data format’ or use what Excel chose for you.