-
Select the cells you want to split and go to Data and choose Text to Columns.
-
Select Delimited and then choose Next,
-
Choose the Delimiters that apply. Check the preview and then select Next.
-
Choose the Column data format and select Finish.
Warning: If there is data in the cells to the right of the cells you're splitting, it may be overwritten.
-
Select the cells you want to split, go to the Data tab and choose Text to Columns.
-
Select the Delimiters.
-
Check the preview and then select Apply.
Warning: If there is data in the cells to the right of the cells you're splitting, it may be overwritten.