CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Bakhtawar Ashiq
Bakhtawar Ashiq

Reputation: 63

Split numbers from column into another column

I have this data in column

image

now i want to extract last numbers and put into another column ..

how i do this

Upvotes: 0

Views: 311

Answers (2)

Error 1004
Error 1004

Reputation: 8240

  1. Select the column with the data
  2. Data tab - Data Tools - Text to Columns
  3. Tick Delimited - Next
  4. Tick Space - Next
  5. Finish

Results:

enter image description here

Upvotes: 0

Davesexcel
Davesexcel

Reputation: 6982

Extract just numbers from a string

=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),99)*1

Upvotes: 2

Related Questions