excel split text into different rows

1.Select the cell or column that contains the text you want to split.

2.Select Data > Text to Columns.

3.In the Convert Text to Columns Wizard, select Delimited 
1
2
3
4
5