Sorting colums in Excel

Any text is considered greater than number in Excel. Hence, all string that has text will end up at bottom.

If you need to sort based on number and then on alphabet, you'd need helper columns or VBA.

Helper column method.

Add 2 columns, 1 for number part and another for text part (use formula etc to extract each).

Then use those 2 columns to sort.

See attached sample (Check sort ribbon tool in data tab).