Subject: | |
From: | |
Reply To: | |
Date: | Thu, 22 Mar 2012 14:30:43 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
If you want to massage the data in Excel, the following formula might
work (assuming your number list is in column A and the formula posted
to the column B):
=IF((LEN(A2)<=8), "ocm"&REPT("0",(8-(LEN(A2))))&A2, "")
If the length of the number in A2 is equal to or less than 8, then add
ocm with leading zeros and the number in A2 so the new number is 11
characters long. Any number under the A column that is more than 8
characters gets a blank in the related B cell.
I tested this on several some random numbers and it appears to work,
but caveat cataloger.
--
Mark K. Ehlert Minitex
Coordinator University of Minnesota
Bibliographic & Technical 15 Andersen Library
Services (BATS) Unit 222 21st Avenue South
Phone: 612-624-0805 Minneapolis, MN 55455-0439
<http://www.minitex.umn.edu/>
________________________________________________________________________
This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]
|
|
|