Explanation

On the Data tab, in the Data Tools group, click Text to Columns.

The Convert Text to Columns Wizard opens.

Choose Delimited if it is not already selected, and then click Next.

Select the delimiter or delimiters to define the places where you want to split the cell content.