I have multiple lists of part numbers, both numeric and alpha numeric in
varying digit numbers and wish to sort them.

Is it not possible to sort a column based on reading the cell from left
to right? ie:001, 111, 2, 22-33, 3, etc.

I have lists that were sorted this way but trace how.

Rgds


--
kaduna
------------------------------------------------------------------------
kaduna's Profile: http://www.excelforum.com/member.php...o&userid=30422
View this thread: http://www.excelforum.com/showthread...hreadid=500921