I have a list of CAS numbers which are in the format xxxxx-xx-x where "x" is a digit from 0 to 9. Example: hexane is 25264-93-1, and ethanol is
64-17-5. Essentially I want to remove the "-" from the string. Any suggestions how this can be done? I tried apply a macro, but this just copied the first number where the "-" were removed.
Help appreciated!
Hi Cruncher,
A quick and easy way would be to select your data and use the Find/Replace dialog. Replace the dash/hyphen character with nothing. You'll be left with just numeric strings.
25264-93-1 will become 25264931.
64-17-5 will become 64175.
If you need something different, let us know!
A formula like
=SUBSTITUTE(A1,"-","")
also works.
The final digit of a CAS registry number is a check digit which is calculated from those preceding it. As a safeguard, you might want to consider putting in a check for validity when manipulating them.
See http://en.wikipedia.org/wiki/CAS_registry_number for details.
Martin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks