Rank the Alphanumeric characters

Hi,

I have alphanumeric characters and I have to rank them. Previously these characters were only digits (Using Rank function) and now some alphabets mixed with them. What is the function to rank Alphanumeric characters? They are like:

1A2240E01
210003004U
216000001U
499630001
463630001
400650001
400650002
499990011
460610001
474640003
7A2215003
7A2110003
7A0000003
7A0000002
7A3300001
474670002
474670001
499990010
499990014
310101002
330101006
330101008
340101001
340101008
7A1000004
7A1000003
7A1000001

I will appreciate your answer over this!

Thanks,

is this same as this one???
http://www.excelforum.com/excel-form...hanumeric.html

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.


Do take a moment to read the Forum Rules, they are very helpful and you are expected to abide them.