Forum Discussion
trs1111
Oct 18, 2023Brass Contributor
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...
- Oct 19, 2023Hi 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!
HansVogelaar
Oct 18, 2023MVP
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)
trs1111
Oct 19, 2023Brass Contributor
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!
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!