sort in excel that sorts digikey

A

Albert Mulder

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,25,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
 
M

Miguel Zapico

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.
 
Top