Splitting text strings without using formulas
To do this, follow next steps:
1. Select cells with consist text that you want to split.
2. On the Data tab, in the Data Tools group, click Text to Columns button:

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

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

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

6. Click Finish.