CODEWITHSUNDEEP
excelsplitnumbersspacing
William Bamber
William Bamber

Reputation: 3

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

Upvotes: 0

Views: 222

Answers (1)

Mayukh Bhattacharya
Mayukh Bhattacharya

Reputation: 27233

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

Demo

enter image description here

  • Select the range.
  • From Data Tab --> First Step --> Delimited --> Next
  • Second Step --> Delimiters as Space --> Next
  • Third Step --> Column Data Format --> Kept as Text you can also keep it General
  • Finish.

Or Use TEXTSPLIT()

=TEXTSPLIT(A2," ")

Or Single Array formula:

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

Upvotes: 0

Related Questions