View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
CS Project Man
 
Posts: n/a
Default Sorting Alpha Numeric Part 2

Thanks for all the suggestions, adding the 00's after the prefix seems the
easy way, I'll just do an Edit Auto fill.

"CS Project Man" wrote:

Here is some more info, I have items that start with 'A' and 'D' prefixs. 'A'
sorting is not a problem since the numbers only go up to A69. The 'D's
however go to 200. Is there any other way to sort, without retyping
everything below 100, so I don't get the result below? Thanks.

A59
A60
A63
A69
D00
D01
D08
D09
D10
D100
D101
D108
D109
D11
D110
D118
D119
D12
D120
D128
D129
D13
D130
D136