How can I put all rows in numeric order by serial number while ignoring the letters in front of the serial numbers? For instance, if I want all rows in order according to the serial number column when the numbers look like:

AA-1010, AA-1009, BC-9999, ZX-0236.

I want Excel to ignore the letters and put them in numeric order, so that the previous list would actually look like:

ZX-0236, BC-9999, AA-1009, AA-1010.

Thanks!