Re: [IUG] Removing check digit in Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Date: Tue, 6 Apr 2010 15:31:44 -0400
- From: Robert Sebek <libinst at vt dot edu>
- Subject: Re: [IUG] Removing check digit in Excel
Every month we export a list of new arrivals. Someone must know how
to easily strip off the check digit from the bib record number
before I add the rest of the url for the persistent link.
LEFT(Cell with bib record number,length of bib record number - 1)
Webmaster, University Libraries, Virginia Tech
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.