Azalea Software, Inc.

Printing Code 39 Barcodes in Excel

Use our Excel plugin to print Code 39 barcodes. This Excel plugin addes the start and stop bars for you.

There are two ways to print Code 39 bar codes in Excel. The simplest way is to add the necessary start and stop bars to your data. The simplest way is to add 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 asterisk has been added to your data in B1, select one of the Code 39 fonts to turn it into a barcode symbol.

To copy this action for a whole column of numbers, select the B column and click Edit/Fill/Down (Ctl-D) This technique works when your data is alphanumeric and you don't want to create a Full ASCII Code 39 symbol and/or use the optional mod 43 check digit.

The other way to make Code 39 barcods in Excel is to use our Excel plug-in. Actually it's 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). Our setup program installs these files by default or you can right click on the filenames and download them yourself.

Open your spreadsheet.

Let's assume your input data is in the A column. The barcodes will be created in the B column. Type the equal sign "=" in cell B1.

The available functions drop down list becomes active (black arrow above A1 cell). Or go to Menu Insert/Function.

Select "More functions". Another window pops up. Choose "User defined" and Azalea's Code 39 functions appear. Select "AzaleaCode39B". Click the OK button.

Direct the function to your data, in this example cell A1. Click the OK button.

Select B1. Go to Format/Cell/Font. Select a Code 39 font and set the point size.

To center the bar code, click the "Alignment" tab and choose Center for horizontal and perhaps vertical.

Select Edit/Fill/Down.

Select A1-A4 / B1-B4, File/Print Preview.