View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default on excel - how sort letters before numbers

Gerry wrote:
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