title: Sort alphanumeric values
body: <p>I need to sort a list of part numbers alphanumerically. Excel will not sort them correctly though when I open the auto filter drop down it shows them in the order that I need.  </p>
  
  <p>They aren't uniform in length, some contain letters, some have leading zeros, with a maximum length of 15 characters. Here is a list along with the correct sorting:</p>
  
  <pre><code>Part       Correct Sort
  00863      00863
  1123       02257
  02257      07706
  6549       10338
  6834       11212
  07706      1123
  8001       65412SSCY
  8001       6549
  10338      6834
  11212      8001
  65412SSCY  8001
  EN93       EN93
  SCSM11BE   SCSM11BE
  </code></pre>
  
  <p>Hoping for a macro or method. </p>