I am trying to sort an Excel sheet based on a column that has a mix of:
- 3 digit numbers (such as 404)
- 3 digit numbers with non-numeric characters appended (such as 802b)
- non-numeric text (such as none or ?)
Excel sorts the plain numbers first, then the rest are sorted together, with the numbers+text in between punctuation marks and alpha characters.
I want the numbers and the numbers+text interleaved. But applying Format > Text to the column does nothing. How do I force it to sort numbers as text?