Alphanumeric sort

**gmf2012** · 01-23-2012, 04:29 PM

Hello all,
I am not the best when it comes to sorting alphanumeric and my excel skills have gotten a bit rusty in the past ten years.

I have a huge range of usernames i need to sort.

probably fairly simple for most of you.

here is an example

cranson002
artmake02
jane01
johnson
rodrigues
adam123

i need to sort them all so that i get the usernames ending in 3 numbers, those ending in 2 numbers and those that do not end in numbers .

thanks,
GMF

**shg** · 01-23-2012, 04:38 PM

      ----A----- -B-- -------------------------C--------------------------
  1      Name    Nums                                                     
  2   cranson002    3 B2: =IFERROR(MATCH(999, --(RIGHT(A2, {1,2,3}))),  0)
  3   adam123       3                                                     
  4   artmake02     2                                                     
  5   jane01        2                                                     
  6   johnson       0                                                     
  7   rodrigues     0

Sort descending by col B