Thread: Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
appeng appeng is offline
external usenet poster
 
Posts: 9
Default Sorting

I am trying to sort alpha-numeric cells all in the same column. But I cannot
get the sort in order.

For example;
COND7
COND8
COND9
COND10
COND11
COND12
COND13
COND14
COND15
COND16
COND17
COND18
COND109
COND110
COND111
COND112
1SHDAE
151E2
30SHDY
31SHDY

Sort Result is not what I would expect
151E2
1SHDAE
30SHDY
31SHDY
COND10
COND109
COND11
COND110
COND111
COND112
COND12
COND13
COND14
COND15
COND16
COND17
COND18
COND7
COND8
COND9