How can I seperate from 1 column to 2 columns. using function. cant use text to column, no integer o

[Alan Skelly]

62 1/2
21/2
11/2        1     1/2
4hd          4     hd
103 1/2   10  3 1/2
31/2         3     1/2
7hd           7    hd
92             9   2
11             11
54 1/2        5   4 1/2
82              8   2

[#2]

@Subodh_Tiwari_sktneer 

That is the same problem I had with the formula approach above. The web page source with the HTML is the only machine readable resource to solve this issue. Looking at the HTML, it is crystal clear what the numbers are. Therefore, web scraping and parsing the HTML will be required for correct results.

[#3]

@Ingeborg Hawighorst

Yes, I completely agree with you.

[#4]

Didnt deal with the issue if behind more than 10 lengths blue highlight either. I have figured a way to fix the 1 or 11 problem. Thanks for trying @Subodh_Tiwari_sktneer