How to sort numbers with text/ letter prefix or suffix in Excel
For example you have a series of numbers containing letter prefix or suffix, how could you sort them as normal numbers in Excel? This article collects several workarounds to get it done.
More details:
https://www.extendoffice.com/document...