sorting table of contents

[bilemery]

I need to sort a table of contents that has multiple decimal points so that all the entries with no decimals are followed by the entries with two decimals etc.

For example
4
4.1
4.2
4.3
4.2.1
4.2.2
4.3.1
4.3.1.1
4.3.1.2.5
4.3.2
4.3.2.1
4.3.1.2

ends up like

4
4.1
4.2
4.3
4.2.1
4.2.2
4.3.1
4.3.2
4.3.1.1
4.3.1.2
4.3.2.1
4.3.1.2.5

I hope I made myself clear

thank you in advance
bil

[111StepsAhead]

So you want them sorted by length after the first number?

[bilemery]

So you want them sorted by length after the first number?

Yes they do not need to be sorted by number I just need all with no decimals followed by those with 1 followed by those with 2 etc

[bilemery]

What I may need to clarify here is the following
I can accomplish what I need to do by counting the decimal points in each number.

[shg]

If your first example is the sort order you want, then just ensure that all the values are text, and when prompted, specify to sort text and text that looks like numbers separately.

If your elements can exceed 9 (e.g., 4,10.2) then you need to do something different, for which I can provide a UDF to help.