2 Replies Latest reply on Oct 27, 2013 7:24 PM by myDavey

    Sorting strings of Letters with Numbers

    myDavey Level 1

      Hi

      I have a list of numbers with letters.

      For example:

      12

      AB

      9A

      C1

       

      I would like to sort them like this

      Numbers go first, then letters, (in both columns respectively), so this is what it should look like:

      12

      9A

      AB

      C1

       

       

      I dont think there is a function for this,

      but if someone can explain to me how to accomplish this the best way possible

      I would really appreciate it!

       

      Thanks in advance

      Davey