Hi everyone

In rhe excel sheet in the link below in the A column there are 5k rows including untidy data.What i want to do is to get all these untidy data in order in column F.I tried a formula but could not succeed at all.Thank you very much for your help.

https://yadi.sk/i/16xRgaKM3LHLou