I have a column of "numbers" in Excel that I would like to sort as follows:
1.1
1.2
1.2.1
1.2.6
1.2.9
1.2.10
1.2.11
1.3
However, regardless if the cell's type is number or text, Excel sorts them as follows:
1.1
1.2
1.2.1
1.2.10
1.2.11
1.2.6
1.2.9
1.3
This could also be called "Natural sorting" -- in a programming language like PHP this would be accomplished by the natsort
function. But I cannot seem to find a way to sort in this manner inside Excel.
To help further provide some context: These numbers represent sections and sub-sections -- not decimals, but rather as list items:
1. Section
1. Sub-section
2. Sub-section
1. Item
6. Item
9. Item
10. Item
11. Item
3. Sub-section