Forum Discussion
How to Sort Mixed Numbers and Text in a column?
You may insert a helper column and use the following formula to extract the Student Numbers in the helper column and then you may sort the helper column either ascending or descending as per your requirement.
The attached is a file with some dummy data, in which column K is the helper column called Student Number and it is sorted in Ascending order. You can replicate the same in your original file.
=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2),LEN(A2)))+0
You may insert a helper column and use the following formula to extract the Student Numbers in the helper column and then you may sort the helper column either ascending or descending as per your requirement.
The attached is a file with some dummy data, in which column K is the helper column called Student Number and it is sorted in Ascending order. You can replicate the same in your original file.
=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2),LEN(A2)))+0
That worked. Thank you very much ... and the example file helped so much.
Stay safe.
Michael
You're welcome Michael! Glad it worked as desired.
Thanks Michael and you too!
