Here is one interesting thing (I guess) from chemistry. I would like to sort by 1st uppercase in the cell. For example, 5 rows in a column have:
2-Butene
Butane
n-Hexane
Hexane
N-Methyl-2-pyrrolidone
(In chemistry, the uppercase is decided by the IUPAC nomenclature)
Normally, A-Z sort in Excel...
