How can I sort a combination of letters and numbers in excel?
For example lets say I have:
1d
1
2e
3
2f
2
3e
1t
excel sorts the numbers first , then the combined entries:
1
2
3
1d
1t
2e
2f
3e
but what I wanted is:
1
1d
1t
2
2e
2f
3
3e
Is there a way to sort it like that?