Forum Discussion
Excel not sorting numbers correctly - smallest to largest etc.
I have been helping a friend organize a excel file with 4 digit numbers. These numbers are in the 6000 to 8000 range. When I filter or sort the numbers from smallest to largest there are numbers , ...
If they are not generated within Excel but copy/pasted from the Web, most probably you have non-printable characters inside your cells with numbers. That doesn't matter you used same site or not.
You may check by LEN() applied to cells if all of them returns 4.
If not you may apply =CLEAN(A1)*1 to such cells to remove non-printable characters.
SergeiBaklan Thank you, the =CLEAN function helped me out immensely. I cannot see any difference between the input and the output, but the output I can sort properly. Thanks again!
DLans , so far so good, you are welcome. You could see the difference if check =LEN(A1) and =LEN(CLEAN(A1)) if in A1 is initial value