I want to sort data that contains numbers and letters. I have tried
formatting the row as text and it still does not work. Everytime I sort it
doesn't list the entires in order but rather the numbers first then the
numbers with letters next. Here is what im trying to sort:

1227
1244
1257
1277
1289
1421
1422
1423
1431
1432
1438
1494
1572
1258-A
1258-B
1258-C
1258-D
1258-F
1258-G
1273-A
1273-B
1273-C
1273-D
1273-E
1273-F
1403-E
1403-G

Can anyone Help!