How to sort list-style numbers in Excel?
Fresh3 days ago
Mar 15, 202610932 viewsConfidence Score0%
0%
Problem
I have a column of "numbers" in Excel that I would like to sort as follows: However, regardless if the cell's type is number or text, Excel sorts them as follows: This could also be called "Natural sorting" -- in a programming language like PHP this would be accomplished by the function. But I cann…
Error Output
1.1 1.2 1.2.1 1.2.6 1.2.9 1.2.10 1.2.11 1.3
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to sort list-style numbers in Excel?
Low Risk
You can make a table to split the values: For each column, use the headings (row 1) and formulas (row 2+): This appears as: Then you can do a custom sort by columns num1, num2 and num3.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix