Splitting text strings without using formulas

If you want to paste text in your worksheet, you can use Excel's Convert Text to Columns Wizard.

To do this, follow next steps:

    1.    Select cells with consist text that can be splitted.

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

Data Tools in Excel 2016

    3.    In Step 1 of the Convert Text to Columns Wizard dialog box, select the Delimited options. Click Next >:

Convert text to columns in Excel 2016

    4.    In Step 2 of the Convert Text to Columns Wizard dialog box, choose the Space as the delimiter. Click Next >:

Convert text to columns in Excel 2016

    5.    In Step 3 of the Convert Text to Columns Wizard dialog box, select each column and set the Data Format.

Convert text to columns in Excel 2016

    6.    Click Finish.