on excel - how sort letters before numbers

[Gerry]

how do you set up a sort to have alpha first, then numeric

 

[Bill Sharpe]

how do you set up a sort to have alpha first, then numeric

Let's say you have the items in Column A.

First sort all, largest to smallest. This will put the letters first,
followed by the numbers but they'll both be in descending order.

Then sort on just the letters in the column, smallest to largest.

Then sort on just the numbers in the column, smallest to largest.

Hope you don't have to do this too often...

Bill