Forum Discussion
Irregular Sorting in Excel
I am having a very strange issue. The SORT result of a Data Column in an Excel file is incorrect when I sort using my Windos Laptop. However, when I do the same sorting function from another computer ...
Select one cell in the column you want to sort.
Press Ctrl + A, to select the entire region.
Check the selected area, to make sure that all the data is included.
On the Excel Ribbon, click the Home tab.
In the Editing group, click the arrow on Sort & Filter.
Click Custom Order.
Press Ctrl + A, to select the entire region.
Check the selected area, to make sure that all the data is included.
On the Excel Ribbon, click the Home tab.
In the Editing group, click the arrow on Sort & Filter.
Click Custom Order.
Data is in a Table format so the Sorting steps are correct. The issue is that ot does not sort in correct order from my Laptop but the same file sorts correctly from other devices.
If your laptop is on Windows did you have a chance to test on another Windows machine? Or perhaps you could submit the file in question here to remove sensitive information.
SergeiBaklanAttached is the file. In one column in the data sorted from another device and in another column is the file sorted from my laptop.
Yes, as Detlef_Lewin mentioned there are about hundred texts with not-printable unicode characters in front. Excel on Windows uses unicode sorting and to my knowledge there is no option to shift on ANSII sorting and back. Not sure how Excel for Mac works, based on your sample it performs ANSII sorting.
On Excel for Windows Power Query sorts correctly ignoring non-printable unicode characters.
