software

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

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 (=quot;Xquot; amp; 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 nicequot;Albert Mulderquot; wrote:

gt; Does anyone know how to sort in gigikey style?
gt;
gt; Example:
gt; 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,
gt;
gt; It needs to sort from left to right not right to left alphanumberic