Guest amy153 Posted February 14, 2006 Share Posted February 14, 2006 Hi, I'm new to this forum but though I'd share a newfound solution to a problem I'd been having for a long time. I have a spreadsheet of compounds along with various properties and common uses etc... which I like to be able to sort by use, or molucular mass for example. My problem was that I could easily sort those sorts of thing, but when it came to sorting the compound names themselves I was stuck!!!! Has anyone else had this problem? Anyway, I thought there might be something in Excel you could use to help, and after literally DAYS of searching the Web I stumbled cross a little known add in for excel called 'Chemical Sorting' which lets you ignore parts of the name like hyphens, commas, brackets, numbers and single letters. I think it's basically a normal sort with the capability of ignoring whatever you want. Oh, you can also ignore italics and bold - which was REALLY useful I found when it came to names beginning 'tert' or 'exo' etc. Anyway, there you go! If anyone has similar experiences, let me know. In the meantime, here’s the link to the tool if you're interested: http://uk.geocities.com/chrisdjames1@btinternet.com/ChemicalSorting.zip (also attached) ChemicalSorting.zip Link to comment Share on other sites More sharing options...
insane_alien Posted February 14, 2006 Share Posted February 14, 2006 could be potentially usefull in the future. BTW i scanned it and its clean. Link to comment Share on other sites More sharing options...
RyanJ Posted February 14, 2006 Share Posted February 14, 2006 Interesting, will prove useful for my chemical information database, thanks for sharing! Cheers, Ryan Jones Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now