Thread: sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
always confused[_2_] always confused[_2_] is offline
external usenet poster
 
Posts: 4
Default sort

I'm trying to use the sort comand on excel so that my list looks like this
05-024
AB05-543
05-678
002-23

What was asked of me is to sort the list so that letters are not taken into
consideration and so that it is sorted by the number of digits to the left of
the hyphen then by value.
Does anyone know how to do this?