Barcode generator on Excel

To use excel to generate a bar code is easy.

1. Download free barcode font

2. Copy the font files to c:\windows\fonts

3. Open an excel file with 2 columns. One column for normal character and another column for barcode.

4. On the second column, paste this formula¬†=CONCATENATE(“*”,A1,”*”)

For open office calc use this formula ¬†=CONCATENATE(“*”;A1;”*”)

5. Choose the “Free 3 of 9 Extended” font

6. Adjust the font size accordingly to get a bigger barcode size

Leave a Reply

Your email address will not be published. Required fields are marked *