ExcelBanter - Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort (https://www.excelbanter.com/excel-worksheet-functions/105377-have-list-items-285-285-36-b-23-d-36-need-sort.html)

Challenged

Have a list of items, 285, 285-A, 36-B, 23-D, 36 and need to sort

Have a database and need to subtotal by a column that has no set number of
characters, some with "-" and a letter after, some just whole numbers. I
want to sort by the whole number and ignore the "-". Ideas?

All times are GMT +1. The time now is 12:15 PM.