Hi,

I want to sort in the following way:

DMA
DMB
MWB
01A
10B
45B
45O
450
451
459

.. list continues for n number of 3-characters combinations.

Problems I have are:
1. The custom list has only 254 lists.... I have more than 30000+ lines
2. My rule is: A-Z, 0-9.
3. I am not able to change the default excel sort...

Can anyone help me.

Thanks
Vasanth