Split numbers in a cell into different cells

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:56 PM GMT

Question

 I have got the string of numbers as the followings:   2     3     5     6     7     8     9    10    14    15

I have copied and pasted them from a notepad sheet. How do i split them in separate cells as one number in each cell in excel? It seems that there is space between numbers that i need to consider? Kim


Answer

Try the TEXT TO COLUMNS feature in Excel. It can break up values based on any separator, like a space.

Advertisement

©2017 eLuminary LLC. All rights reserved.