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.
[TABLE="width: 100"]
<tbody>[TR]
[TD]Current order
[/TD]
[/TR]
[TR]
[TD]3.
[/TD]
[/TR]
[TR]
[TD] 3.10
[/TD]
[/TR]
[TR]
[TD] 3.10.1
[/TD]
[/TR]
[TR]
[TD] 3.2
[/TD]
[/TR]
[TR]
[TD] 3.2.1
[/TD]
[/TR]
[TR]
[TD]10.
[/TD]
[/TR]
[TR]
[TD] 10.9
[/TD]
[/TR]
[TR]
[TD] 10.9.1
[/TD]
[/TR]
[TR]
[TD] 10.1
[/TD]
[/TR]
[TR]
[TD] 10.1.2
[/TD]
[/TR]
[TR]
[TD]2.
[/TD]
[/TR]
[TR]
[TD] 2.1
[/TD]
[/TR]
[TR]
[TD] 2.1.1
[/TD]
[/TR]
</tbody>[/TABLE]

Regards Tomas

 

[Andrew Poulsom]

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

[TABLE="width: 48"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]03[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]03.10[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]03.10.1[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]03.02[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]03.02.1[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]10[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]10.09[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]10.09.1[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]10.01[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]10.01.2[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]02[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]02.01[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]02.01.1[/TD]
[/TR]
</TBODY>[/TABLE]

 

[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.