ExcelBanter - How to sort text and letter hybrid (eg A1, A2, A10) in order?

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

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

- - How to sort text and letter hybrid (eg A1, A2, A10) in order? (https://www.excelbanter.com/excel-worksheet-functions/78776-how-sort-text-letter-hybrid-eg-a1-a2-a10-order.html)

Amy

How to sort text and letter hybrid (eg A1, A2, A10) in order?

All times are GMT +1. The time now is 11:55 PM.