Example:
Code 3 of 9 is the most popular barcode for encoding alpha-numeric characters.
Key features:
How to Generate a Code 39 Barcode for Excel Firstly, activate 'Barcode Settings' panel to choose 'CODE 39' and type required data. Then click 'Generate' to create the single Code 39 image into the Microsoft Excel workbook (To remove it, click 'Delete'). How to Configure Code 39 within Setting Panel on Excel.
- The Code 39 character set can be extended to a full set of ASCII characters by using 1 or 2 normal characters for each character in the extended set. Note that a barcode reader cannot automatically determine whether a barcode is encoded normally or in the extended set. The following table shows how to encode the full set of ASCII characters.
- Highlight the whole string and select one of Code 39 fonts. Adjust the barcode size and human readable text option by selecting a different font, or adjusting font size. It is possible to encode lower case letter using code 39 fonts. However, you will need to convert the.
- 2 different width of bar/space.
- Symbol set contains 43 characters: A-Z, 0-9, and -, ., *, $, /, +, %, SPACE.
- Each character is made up of 5 bars and 4 spaces with 3 wide bars/spaces and 6 narrow bars/spaces.
- There is a space between each character.
- The first and last character should always be the same (the * character)
- The first and last 5 black bars should always follow the pattern: narrow, narrow, wide, wide, narrow.
- The number of black bars should be divisible by 5.
- Optional checksum character modulus 43.
- Extended Code 39 uses 2 normal characters to represent one extended character, giving a 128-character symbol set.
Specification:
Symbol | Narrow/Wide Pattern | Visual Pattern | Checksum Value |
* | NWNNWNWNN | N/A | |
0 | NNNWWNWNN | 0 | |
1 | WNNWNNNNW | 1 | |
2 | NNWWNNNNW | 2 | |
3 | WNWWNNNNN | 3 | |
4 | NNNWWNNNW | 4 | |
5 | WNNWWNNNN | 5 | |
6 | NNWWWNNNN | 6 | |
7 | NNNWNNWNW | 7 | |
8 | WNNWNNWNN | 8 | |
9 | NNWWNNWNN | 9 | |
A | WNNNNWNNW | 10 | |
B | NNWNNWNNW | 11 | |
C | WNWNNWNNN | 12 | |
D | NNNNWWNNW | 13 | |
E | WNNNWWNNN | 14 | |
F | NNWNWWNNN | 15 | |
G | NNNNNWWNW | 16 | |
H | WNNNNWWNN | 17 | |
I | NNWNNWWNN | 18 | |
J | NNNNWWWNN | 19 | |
K | WNNNNNNWW | 20 | |
L | NNWNNNNWW | 21 | |
M | WNWNNNNWN | 22 | |
N | NNNNWNNWW | 23 | |
O | WNNNWNNWN | 24 | |
P | NNWNWNNWN | 25 | |
Q | NNNNNNWWW | 26 | |
R | WNNNNNWWN | 27 | |
S | NNWNNNWWN | 28 | |
T | NNNNWNWWN | 29 | |
U | WWNNNNNNW | 30 | |
V | NWWNNNNNW | 31 | |
W | WWWNNNNNN | 32 | |
X | NWNNWNNNW | 33 | |
Y | WWNNWNNNN | 34 | |
Z | NWWNWNNNN | 35 | |
– | NWNNNNWNW | 36 | |
. | WWNNNNWNN | 37 | |
SPACE | NWWNNNWNN | 38 | |
$ | NWNWNWNNN | 39 | |
/ | NWNWNNNWN | 40 | |
+ | NWNNNWNWN | 41 | |
% | NNNWNWNWN | 42 |
Checksum Calculation:
The checksum is modulus 43 sum of all the checksum values from the table above.
For example, if you are encoding the string ABCD1234 then the checksum values will be 10 + 11 + 12 + 13 + 1 + 2 + 3 + 4 = 56.
56 mod 43 = 13. So the checksum character should be D.
Extended Code 39
The Code 39 character set can be extended to a full set of ASCII characters by using 1 or 2 normal characters for each character in the extended set.
Note that a barcode reader cannot automatically determine whether a barcode is encoded normally or in the extended set.
The following table shows how to encode the full set of ASCII characters:
NUL | %U | SUB | $Z | 4 | 4 | N | N | h | +H |
SOH | $A | ESC | %A | 5 | 5 | O | O | i | +I |
STX | $B | FS | %B | 6 | 6 | P | P | j | +J |
ETX | $C | GS | %C | 7 | 7 | Q | Q | k | +K |
EOT | $D | RS | %D | 8 | 8 | R | R | l | +L |
ENQ | $E | US | %E | 9 | 9 | S | S | m | +M |
ACK | $F | SPACE | SPACE | : | /Z | T | T | n | +N |
BEL | $G | ! | /A | ; | %F | U | U | o | +O |
BS | $H | “ | /B | < | %G | V | V | p | +P |
HT | $I | # | /C | = | %H | W | W | q | +Q |
LF | $J | $ | /D | > | %I | X | X | r | +R |
VT | $K | % | /E | ? | %J | Y | Y | s | +S |
FF | $L | & | /F | ? | %V | Z | Z | t | +T |
CR | $M | ‘ | /G | A | A | [ | %K | u | +U |
SO | $N | ( | /H | B | B | %L | v | +V | |
SI | $O | ) | /I | C | C | ] | %M | w | +W |
DLE | $P | * | /J | D | D | ^ | %N | x | +X |
DC1 | $Q | + | /K | E | E | _ | %O | y | +Y |
DC2 | $R | , | /L | F | F | ‘ | %W | z | +Z |
DC3 | $S | – | – | G | G | a | +A | { | %P |
DC4 | $T | . | . | H | H | b | +B | | | %Q |
NAK | $U | / | /O | I | I | c | +C | } | %R |
SYN | $V | 0 | 0 | J | J | d | +D | ~ | %S |
ETB | $W | 1 | 1 | K | K | e | +E | DEL | %T |
CAN | $X | 2 | 2 | L | L | f | +F | DEL | %X |
EM | $Y | 3 | 3 | M | M | g | +G | DEL | %Z |
Code39 Extended Barcode
This is an extended version of the Code39 barcode that supports the full ASCII character set. If there isa requirement to use the Code39 barcode with characters other than numbers and uppercase alphabets, thenthis is the recommended barcode. As this barcode is based on Code39, it is also very simple and easy to use. It is, however, not the most dense in terms of number of characters per inch.
Generating this barcode using the Barcode Generator
The easiest way to create this barcode is to use the Barcode Generator included in the installation package. Simply goto the Start Menu and launch Aeromium Barcode Fonts > Barcode Generator. This software automatesand simplifies the creation of the barcodes for you. After the barcode is created, you can simply copyand paste the barcode into your documents.
Generating this barcode using the Barcode Generator
Generating this barcode in Excel
Generating this barcode using the Barcode Generator
Generating this barcode in Excel
Code39 Extended Barcode Fonts
The following is the list of fonts with varying heights supported by Aeromium for Code 39 Extended. The fonts are the same as those in Code 39.
FontCode39H1.ttf
FontCode39H2.ttf
FontCode39H3.ttf (Default Font)
FontCode39H4.ttf
FontCode39H5.ttf
FontCode39H6.ttf
FontCode39H1.ttf
FontCode39H2.ttf
FontCode39H3.ttf (Default Font)
FontCode39H4.ttf
FontCode39H5.ttf
FontCode39H6.ttf
Using this Barcode Manually
The following table lists the characters supported by the Code39 Extended barcode. The basic characters are the same as Code39 barcode. The extendedcharacters are shown on the second table.Characters Supported | Values used for calculating Check Digit |
'0' | 0 |
'1' | 1 |
'2' | 2 |
'3' | 3 |
'4' | 4 |
'5' | 5 |
'6' | 6 |
'7' | 7 |
'8' | 8 |
'9' | 9 |
'A' | 10 |
'B' | 11 |
'C' | 12 |
'D' | 13 |
'E' | 14 |
'F' | 15 |
'G' | 16 |
'H' | 17 |
'I' | 18 |
'J' | 19 |
'K' | 20 |
'L' | 21 |
'M' | 22 |
'N' | 23 |
'O' | 24 |
'P' | 25 |
'Q' | 26 |
'R' | 27 |
'S' | 28 |
'T' | 29 |
'U' | 30 |
'V' | 31 |
'W' | 32 |
'X' | 33 |
'Y' | 34 |
'Z' | 35 |
'-' | 36 |
'.' | 37 |
' ' space | 38 |
'$' | 39 |
'/' | 40 |
'+' | 41 |
'%' | 42 |
'*' (Start/Stop Character) |
Extended Characters
All Extended characters are made up of multiple Code39 characters.
Extended Characters | Code 39 Characters |
NUL | '%U' |
SOH | '$A' |
STX | '$B' |
ETX | '$C' |
EOT | '$D' |
ENQ | '$E' |
ACK | '$F' |
BEL | '$G' |
BS | '$H' |
HT | '$I' |
LF | '$J' |
VT | '$K' |
FF | '$L' |
CR | '$M' |
SO | '$N' |
SI | '$O' |
DLE | '$P' |
DC1 | '$Q' |
DC2 | '$R' |
DC3 | '$S' |
DC4 | '$T' |
NAK | '$U' |
SYN | '$V' |
ETB | '$W' |
CAN | '$X' |
EM | '$Y' |
SUB | '$Z' |
ESC | '%A' |
FS | '%B' |
GS | '%C' |
RS | '%D' |
US | '%E' |
'!' | '/A' |
'' | '/B' |
'#' | '/C' |
'$' | '/D' |
'%' | '/E' |
'&' | '/F' |
'' | '/G' |
'(' | '/H' |
')' | '/I' |
'*' | '/J' |
'+' | '/K' |
',' | '/L' |
'/' | '/O' |
':' | '/Z' |
';' | '%F' |
'<' | '%G' |
'=' | '%H' |
'>' | '%I' |
'?' | '%J' |
'[' | '%K' |
' | '%L' |
']' | '%M' |
'^' | '%N' |
'_' | '%O' |
'a' | '+A' |
'b' | '+B' |
'c' | '+C' |
'd' | '+D' |
'e' | '+E' |
'f' | '+F' |
'g' | '+G' |
'h' | '+H' |
'i' | '+I' |
'j' | '+J' |
'k' | '+K' |
'l' | '+L' |
'm' | '+M' |
'n' | '+N' |
'o' | '+O' |
'p' | '+P' |
'q' | '+Q' |
'r' | '+R' |
's' | '+S' |
't' | '+T' |
'u' | '+U' |
'v' | '+V' |
'w' | '+W' |
'x' | '+X' |
'y' | '+Y' |
'z' | '+Z' |
'{' | '%P' |
'|' | '%Q' |
'|' | '%R' |
'~' | '%S' |
DEL | '%T' |
Examples
To encode the data 'abcd' without the check digit manually, simply key in '*+A+B+C+D*' and select the FontCode39H3.ttf font. The output is as follows :
To encode the data 'abcde' with the check digit manually, simply key in '*+A+B+C+D+E7*' and select the FontCode39H3.ttf font. The output is as follows :
The '7' is the check digit and its computation is illustrated in the section below.
How to compute the check digit
The Code39 barcode uses the Modulo 43 Check Digit computation.Supported Characters | + | A | + | B | + | C | + | D | + | E |
Values | 41 | 10 | 41 | 11 | 41 | 12 | 41 | 13 | 41 | 13 |
Sum : | 41 + 10 + 41 + 11 + 41 + 12 + 41 + 13 + 41 + 14 = 265 | |||||||||
Modulo 43 : | 265 % 43 = 7 (which is the character '7') |