I am trying to sot several thousand items of equipment tracked by their
serial numbers. These serial numbers are items manufactured by many
different manufactures.

The problem is these serial numbers can be:
- Anywhere from one to N characters long. (Let's say ten).
- Some have leading zeros and if so, zeros these are significant
- Some serial numbers may have alpha characters embedded in the number

I am looking for some way to tell MS EXCEL, to sort these numbers from right
to left, (so two digit numbers show up before three digit numbers, etc.) And
"right hand" place holder alpha characters sorted before "left hand" place
holders.

Since some nationalities write from right to left, I would think that
someone, somewhere has run into this before.

Does anybody have any suggestions?

Thanks,
Maurice