Question Is it possible to take a list of numbers and put each one of them in a different cell

3724 views excel

I have a lot of data sequences I need to statistically analyze. The problem is that the numbers are separated by a space character. I need each number to be in a different excel cell. Is there a way to tell excel to use the space as "move the next number to a different cell"?

For example: 1 2 3 4 needs to go to 4 cells: | 1 | 2 | 3 | 4 |

If i just do copy paste, excel (obviously) puts all the numbers in the same cell: | 1 2 3 4 |

Which is not what i need..

Thank you!

answered question

1 Answer


Maybe you could use "Text to Columns":

Go to "Data" -> "Text to Columns". In the window that pop-up choose "Delimited". Then click "Next >".

enter image description here

Choose "Space" as your delimiter. Click "Finish".

enter image description here

The result is that Excel converts all the cells with values if they are separated by a space to individual cells.

enter image description here

posted this

Have an answer?


Please login first before posting an answer.