excelsplitnumbersspacing

Split out numbers in a column


I'm trying to split out the two numbers in the cell into separate columns

I've tried "text to columns", using the delimitator "space" but it removes the second number in each of the cells leaving me with only the first number.

enter image description here


Solution

  • Not sure what you did, but it works on my end, please see Demo:

    Demo


    enter image description here



    Or Use TEXTSPLIT()

    =TEXTSPLIT(A2," ")
    

    Or Single Array formula:

    =TEXTSPLIT(TEXTAFTER(" "&A2:A24," ",{1,2})," ")