Trouble sorting rows in Excel

[tomkar]

Hi,

I am having problem with sorting the following rows according to its values in an ascending order. I would like to have it sorted based on the number before the first dot "x." then the middle number and finally the last number.

I have tried filter, advanced sort, but I cant seem to get it to work. I need mrExcels expertise.

Current order
3.
3.10
3.10.1
3.2
3.2.1
10.
10.9
10.9.1
10.1
10.1.2
2.
2.1
2.1.1

<tbody>
</tbody>

Regards Tomas

 

[Andrew Poulsom]

To do that the length of each section must be the same:

03
03.10
03.10.1
03.02
03.02.1
10
10.09
10.09.1
10.01
10.01.2
02
02.01
02.01.1

<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>

 

[tomkar]

OK, yes that works. Thanks for the quick answer.

But if I would like to keep it as the original, without even sections, is it possible to sort it using VBA? And if so, how? I am curious because I had another sorting issue in another file which involved vba.