Forum Discussion
Alphanumeric sorting
I have two columns that are connected and I want to sort by the second column, I want it sorted numerically but it keeps moving the numbers with the -1631 to the bottom of the list how do I fix this?...
lxj190 Sort by the numeric column but look at the alphanumeric..?
...or turn the column into text format making the numbers treated as strings.
Menu Home: Number:
Thank you I did try to turn it into text, but it didn't work on all my columns, I found that if I put an ' in front of the number without the dash it gives me the warning box and I can pick sort as text. So thank you for the help
lxj190 Right- if the invoice number not always begins numeric, then it will not work as proposed.
Good that the apostrophe (comment character) helps. And yet another possibility may be even more helpful;
=IFERROR(TEXT(F6:F18,"0"),F6:F18)
try to turn the data into text, and if it fails, treat it as already text.
Assuming Excel 365, there is only one formula, spilling the result. If Excel PDA/pre dynamic arrays, use
=IFERROR(TEXT(F6,"0"),F6)
and fill down.