Search results

Thanks for your kind reply and the VB code! Yes, I understand it has limitations. Honestly, the thing I am trying to achieve is fairly complex. So, let's see.

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...