How to: Use formula to sort alphanumeric data

[MDX2013]

How would I sort this data (using a formula) ascending by number and then letter?

17091780-02A

17091555-01A

17091555-01ADUP

17091555-02A

17091559-01A

<colgroup><col></colgroup><tbody>
</tbody>

 

[mole999]

i think these work best with spare column(s), splitting out the number from the letters then sorting by those two columns. they don't have to be visible to work

 

[István Hirsch]

Try this:

Excel Workbook
	A	B
2	17091780-02A	17091555-01A
3	17091555-01A	17091555-01ADUP
4	17091555-01ADUP	17091555-02A
5	17091555-02A	17091559-01A
6	17091559-01A	17091780-02A
Sheet1