Hello all,
Could anyone advise how we could sort the following list of numerical and alphanumerical values in a numerical way?
Issue: when sorted in excel the values with alphabetical characters in are dropped to the bottom of the list. See data below:
275
453
523
531
622
644
1046
1055
1055XL
485XL
585XL
685XL
The way we want the data sorted is below. So just taking into account the numerical value in the cell.
275
453
485XL
523
531
585XL
622
644
685XL
1046
1055
1055XL
Hope the above makes sense. Any help would be greatly appreciated.
Thanks, EAG1
Could anyone advise how we could sort the following list of numerical and alphanumerical values in a numerical way?
Issue: when sorted in excel the values with alphabetical characters in are dropped to the bottom of the list. See data below:
275
453
523
531
622
644
1046
1055
1055XL
485XL
585XL
685XL
The way we want the data sorted is below. So just taking into account the numerical value in the cell.
275
453
485XL
523
531
585XL
622
644
685XL
1046
1055
1055XL
Hope the above makes sense. Any help would be greatly appreciated.
Thanks, EAG1