Printing Code 39 Barcodes in Excel
Our Excel plugin helps you make Code 39 barcodes in Excel 2002-2007. Our plugin adds the start and stop bars for you.
You can make Code 39 bar codes one of two ways in Excel. The simplest way is to add the necessary start and stop bars to your data; this means adding the asterisk used as the Code 39 start and stop bar to your input string. For example, if your data is in the A column and you want to create Code 39 barcodes in the B column, type this in B1: =CONCATENATE("*",A1,"*")
After the asterisks have been added to your data in B1, select one of Azalea’s Code 39 fonts to convert it into a scannable barcode symbol. If you want to copy this action for a whole column of data, select the B column and click Edit/Fill/Down (Ctrl-D) This is the fastest easiest way to make Code 39 barcodes using Azalea’s barcode fonts if your data are alphanumeric and you don’t want to create a Full ASCII Code 39 symbol and/or use the optional mod 43 check digit.
The second way to make Code 39 barcodes in Excel is to use our Excel XLA plug-in. In fact, the plugin is two files: barcode.dll which goes into your \WINDOWS\SYSTEM32 (or \WINNT\SYSTEM32) directory and AzaleaBarCodes.xla which goes into your XLStart directory (Program Files\Microsoft Office\OFFICE11\XLSTART or \OFFICE12\XLSTART) Our Code39Tools for Windows program installs these files by default or you can right click on the filenames to download and install them manually.
Open your Excel spreadsheet.
We’ll assume that your input data is in the A column and that we want to create your barcodes in the B column. Type the equal sign “=” in cell B1.
The available functions drop down list becomes active (black arrow above A1 cell). You can alternately go your menu and select Insert and then Function.
Choose “More functions,” and a second window will pop open. Then choose “User defined” and Azalea’s Code 39 functions appear. Select “AzaleaCode39” or “Azalea Code39ASCII” as appropriate, then click the OK button.
Choose the cell that your data is in; in our example, it’s cell A1. Click OK.
Choose cell B1 and then Format>Cell>Font. Select an Azalea Code 39 font from the list and then set the point size.
It’s a good idea to center your barcode in the cell. To do so, click the “Alignment” tab and then Center for horizontal and perhaps vertical.
Then to copy our work over to all our cells in the B column, choose Edit>Fill>Down, or press shift-enter in cell B1.
Now it’s time to print our barcodes! In this case where we have four examples, select A1-A4 / B1-B4, and then File>Print>Preview.
Your print preview will come up and it should look like this. Once you’re ready to print your barcodes, press “Print.” If the output result differs or you see boxes or odd characters in the preview, please send a screenshot to technicalsupport at azalea dot com and we’ll be happy to help you get it sorted out.
