Sort alphabetically and by string length

  • I have cells that I need to sort alphabetically and by the number of characters. For example: I'll have cells with values AV-10 / AV-100 / AV-20 / AV-200 / BV-10 / BV-100 / BV-20 / BV-200

    Sorting alphabetically gives me:

    AV-10

    AV-100

    AV-20

    AV-200

    BV-10

    BV-100

    BV-20

    BV-200

    However, I need it to be sorted like:

    AV-10

    AV-20

    AV-100

    AV-200

    BV-10

    BV-20

    BV-100

    BV-200

    Any help is very appreciated.

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!