Forum Discussion
Sort does not work properly
Pretext: I know this has been done to death, but my problem is different. At work there is a document which is used for organizing inventory. There is a column called "Location" (A1) where they g...
Deleted
You could either replace the column or add a column with leading 0s in order to make the alphabetical order line up with numerical ordering.
= REPT(0,4-LEN(location))&locationSorting on the new column (either the SORT function in 365 or manual sort in older versions) will restore your original ordering.