View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
yip
 
Posts: n/a
Default sort alphanumeric data

I have data with mix number of digits and I like to sort them. Somehow, the
normal sorting process give me a not so desired result. Can anyone help?
A10
B100
A2
AA1
AD200
A1
The result I am looking for is:
A1
A2
A10
B2
B100
AD200