hi all,
I have hundred rows of data like below, how can I spilt them into column with the numbers?
I have tried hlookup,index,etc.. but lost along the way.
Any hints will be very much appreciate

Capture.JPG
2.JPG