I need to sort alphanumeric data. The sorting has to be based on the numbers irrespective of the alphabets.
Current format and order:
2 = GHNB
1 = XGV
8 = ADKH
5 = MNJSDV
Required order
8 = ADKH
5 = MNJSDV
2 = GHNB
1 = XGV
Please note that I have 1000s of columns of data and need...