* Select the cell or cells whose contents you want to split. Important: When you split the contents, they will overwrite the contents in the next cell to the right, so make sure to have empty space there. * On the Data tab, in the Data Tools group, click Text to Columns . The Convert Text to Columns Wizard…