Chemical Sorting (Excel Add-in to alphabetically sort chemicals)
ChemicalSorting is an advanced sorting Add-In tool for Microsoft Excel. It has been designed especially for use with chemical names which often contain numerous symbols, numbers, font styles and single letters, all of which can cause great difficulty when it comes to sorting chemical names into logical alphabetical order.
There are several options available to you to make sorting chemical names (and indeed other text containing elements to ignore) a simple task.
To perform a sort, first click on a cell that is from the column of chemical names which you want to sort. Then click the 'ChemSort' button on the Stardard Toolbar at the top of the Microsoft Excel window. The ChemicalSorting dialog will appear with the ActiveCell set to the cell which you selected. If you made a mistake and want to change the ActiveCell, click 'Cancel', select the correct cell and then click 'ChemSort' again.
In the 'Ignoring' box you can edit the symbols and characters that you want to ignore in the sort. By default all numbers and some commonly occurring symbols in chemical names are ignored.
By default the sort also ignores italic and bold font, spaces between words and single letters (eg the 'D' in D-lactose). You can include these items in your sort by un-checking the relevant checkbox under 'Also Ignore'. If the item is ticked then it will be ignored by the sort.
By default the sort will be returned in ascending order. To have your names sorted in descending order instead, select 'Descending' under 'Sort Order'.
By default it is assumed that your data contains a header row (a title, eg 'Compound names'). If there is no header row then select 'No header row' under 'Header Row'.
VBAExcel Solutions provides full customer support. If you have questions regarding installation and / or use then we will be happy to help.
System Requirements: Microsoft Excel 97 or Later.