Thread: How do i set up a list that sorts as Number/letter/number in orde
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
xorex xorex is offline
external usenet poster
  
Posts: 2
Default How do i set up a list that sorts as Number/letter/number in orde
Hi, I am trying to make a list of numbers which will automatically sort in a
number/letter/number format.
IE; 1A1;
1A2;
2A1;
2A3;
2X9;
3A1;
69A50001;
70A7;
etc, etc.
Any help appreciated.
Mike.
Reply With QuoteReply With Quote