Splitting text strings without using formulas
To do this, follow the next steps:
1. Select cells with the text that should be split.
2. On the Data tab, in the Data Tools group, click Text to Columns button:
![Data Tools in Excel 2016 Data Tools in Excel 2016](/images/tips/167_2016/1.png)
3. In the Convert Text to Columns Wizard - Step 1 of 3 dialog box, select the Delimited options, then click Next >:
![Convert text to columns in Excel 2016 Convert text to columns in Excel 2016](/images/tips/167_2016/2.png)
4. In the Convert Text to Columns Wizard - Step 2 of 3 dialog box, choose the Space as the delimiter, then click Next >:
![Convert text to columns in Excel 2016 Convert text to columns in Excel 2016](/images/tips/167_2016/3.png)
5. In the Convert Text to Columns Wizard - Step 3 of 3 dialog box, select each column and set the Data Format if needed.
![Convert text to columns in Excel 2016 Convert text to columns in Excel 2016](/images/tips/167_2016/4.png)
6. Click Finish.
See also this tip in French: Fractionner des chaînes de texte sans utiliser de formules.