sort in excel that sorts digikey
 

Does anyone know how to sort in gigikey style?

Example:
1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,2 5,26,27,28,29,3,30,31,4,5,6,7,8,9,

It needs to sort from left to right not right to left alphanumberic

sort in excel that sorts digikey
 

You can use a trick, put all the numbers to sort on a column (say A) and in
the column beside add some text with a formula like (="X" & A1). Sort by this
column, and the A column will be sorted in the gigikey stile.
--
It is nice to be important, but it is more important to be nice


"Albert Mulder" wrote:

Does anyone know how to sort in gigikey style?

Example:
1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,2 5,26,27,28,29,3,30,31,4,5,6,7,8,9,

It needs to sort from left to right not right to left alphanumberic