Forum Discussion
Sorting Scientific Notation, Alpha, Numeric, and Alphanumeric
Spent much time looking for a way to sort this data set (which is in an Excel worksheet table as part of a much larger dataset) such that it's in order from A to Z and of course all of the rows in th...
- Hi Hans,
As mentioned in my private message to you, I re-attempted the sort successfully on Excel for the web and another PC that is running a different build of Excel desktop. So it appears that the sort issue has something to do with the Excel desktop build on my other PC.
Thank you again for your time and expertise!
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans,
Thanks for taking a look at this. The sample below is purely fictious, but somewhat representative of the full dataset. I don't see an option to attach this as file and not able to send a link for OneDrive, Google Drive, Dropbox, etc. Hopefully you can work with this sample. The sorting on the "Code" column in the table is the issue.
| Description | Code | Inventory Qty. | Cost |
| Gloves, Black - Small | 011 | 28 | $3.99 |
| Gloves, Black - Medium | 023 | 40 | $4.99 |
| Gloves, Black - Large | 034 | 29 | $5.99 |
| Gloves, Brown - Small | 7E1 | 310 | $3.99 |
| Gloves, Brown - Medium | 085 | 11 | $4.99 |
| Gloves, Brown - Large | 107 | 54 | $5.99 |
| Gloves, Blue - Small | 229 | 23 | $3.99 |
| Gloves, Blue - Medium | 270 | 54 | $4.99 |
| Gloves, Blue - Large | 360 | 71 | $5.99 |
| Gloves, Red - Small | 420 | 94 | $3.99 |
| Gloves, Red - Medium | 501 | 5 | $4.99 |
| Gloves, Red - Large | 627 | 44 | $5.99 |
| Gloves, White - Small | 901 | 63 | $3.99 |
| Gloves, White - Medium | 09G | 741 | $4.99 |
| Gloves, White - Large | 0Z5 | 45 | $5.99 |
| Mittens - Orange | 39Z | 55 | $2.99 |
| Mittens - Red | 3G5 | 9 | $2.99 |
| Mittens - Blue | 41N | 72 | $2.99 |
| Mittens - Green | 55Q | 34 | $2.99 |
| Mittens - Yellow | 6DZ | 45 | $2.99 |
| Mittens - Black | 7FF | 16 | $2.99 |
| Mittens - Purple | 82A | 112 | $2.99 |
| Mittens - Pink | 98E | 33 | $2.99 |
| Mittens - White | 99R | 4 | $2.99 |
I pasted your sample data into an Excel sheet formatted as text, then sorted on the Code column:
Perhaps you can attach a sample workbook in a private message to me (click on my user picture)
- Hi Hans,
As mentioned in my private message to you, I re-attempted the sort successfully on Excel for the web and another PC that is running a different build of Excel desktop. So it appears that the sort issue has something to do with the Excel desktop build on my other PC.
Thank you again for your time and expertise!
