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.
Heather Parker
LEFT(Cell with bib record number,length of bib record number - 1)
LEFT(A1,8)
--
Robert Sebek
Webmaster, University Libraries, Virginia Tech
http://www.lib.vt.edu
(540) 231-1849
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.