How to: Use formula to sort alphanumeric data

[MDX2013]

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

[TABLE="width: 118"]
<colgroup><col></colgroup><tbody>[TR]
[TD]17091780-02A[/TD]
[/TR]
[TR]
[TD]17091555-01A[/TD]
[/TR]
[TR]
[TD]17091555-01ADUP[/TD]
[/TR]
[TR]
[TD]17091555-02A[/TD]
[/TR]
[TR]
[TD]17091559-01A
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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