CREATE BARCODE LABELS IN EXCEL

we have several excel sheets that were developed to print out barcodes when we could still print out barcodes with the 'Bar codes and more' memory sticks. I now need to get those converted to pdf documents with the printable barcodes. Two files uploaded, we want to convert 40-327A to the 40-327 so we can print on label sheets that are 5 across by 10 down.