Barcode Fonts Helper - Excel Custom Functions

Barcode Fonts Helper enables you to create barcodes using fonts on Microsoft 365 Office (Excel and Word) easily.

Quick Overview

  • First, encode your data with the Formulas available in Barcode Fonts Helper. For example, to create a Code 39 barcode, you can use the following formula:


    =CONNECTCODE.ENCODE_CODE39(A1,1)

    This is illustrated in the screenshot below:

  • Next, apply a barcode font to the output generated above to display the barcodes. For example, set the cell to a CCode39_S3 font to display an ISO/GS1 compliant barcode.


All the barcodes supported by Barcode Fonts Helper are listed below. Simply use an Excel Custom Barcode Function with an appropriate Barcode Font to create the type of barcode you require.

Quick Links

List of ConnectCode's Barcode Excel Custom Functions

See how to use ConnectCode's Barcode Excel Custom Functions to create barcodes with this Office Barcode Add-In.

  • Codabar Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODECODABAR(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODECODABAR_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCodabar_S1
    CCodeCodabar_S2
    CCodeCodabar_S3 (ConnectCodeCodabar_S3.ttf Default)
    CCodeCodabar_S4
    CCodeCodabar_S5
    CCodeCodabar_S6
    CCodeCodabar_S7

  • Code 39 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE39(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE39_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCode39_S1
    CCodeCode39_S2
    CCodeCode39_S3 (ConnectCodeCode39_S3.ttf Default)
    CCodeCode39_S4
    CCodeCode39_S5
    CCodeCode39_S6
    CCodeCode39_S7

    CCodeCode39_HS3 (embedded Human Readable Text)

  • Code 39 ASCII (Extended) Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE39ASCII(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE39ASCII_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCode39_S1
    CCodeCode39_S2
    CCodeCode39_S3 (ConnectCodeCode39_S3.ttf Default)
    CCodeCode39_S4
    CCodeCode39_S5
    CCodeCode39_S6
    CCodeCode39_S7

    CCodeCode39_HS3 (embedded Human Readable Text)

  • Code 93 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE93(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE93_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCode93_S1
    CCodeCode93_S2
    CCodeCode93_S3 (ConnectCodeCode93_S3.ttf Default)
    CCodeCode93_S4
    CCodeCode93_S5
    CCodeCode93_S6
    CCodeCode93_S7

  • Code 128A Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE128A(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE128A_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts

    CCodeCode128_S1
    CCodeCode128_S2
    CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
    CCodeCode128_S4
    CCodeCode128_S5
    CCodeCode128_S6
    CCodeCode128_S7

  • Code 128B Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE128B(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE128B_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts

    CCodeCode128_S1
    CCodeCode128_S2
    CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
    CCodeCode128_S4
    CCodeCode128_S5
    CCodeCode128_S6
    CCodeCode128_S7

    CCodeCode128B_HS3 (embedded Human Readable Text)

  • Code 128C Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE128C(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE128C_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts

    CCodeCode128_S1
    CCodeCode128_S2
    CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
    CCodeCode128_S4
    CCodeCode128_S5
    CCodeCode128_S6
    CCodeCode128_S7

  • Code 128 Auto Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_CODE128AUTO(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_CODE128AUTO_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts

    CCodeCode128_S1
    CCodeCode128_S2
    CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
    CCodeCode128_S4
    CCodeCode128_S5
    CCodeCode128_S6
    CCodeCode128_S7

  • EAN13 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_EAN13(PARAM1,PARAM2)

    PARAM1 - Input Data
    PARAM2 - Extended Style

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_EAN13_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts (Standard Style)

    CCodeCodeUPCEAN_S1
    CCodeCodeUPCEAN_S2
    CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
    CCodeCodeUPCEAN_S4
    CCodeCodeUPCEAN_S5
    CCodeCodeUPCEAN_S6
    CCodeCodeUPCEAN_S7

    Fonts (Extended Style)

    CCodeCodeUPCEAN_HRBS1
    CCodeCodeUPCEAN_HRBS2
    CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
    CCodeCodeUPCEAN_HRBS4
    CCodeCodeUPCEAN_HRBS5
    CCodeCodeUPCEAN_HRBS6
    CCodeCodeUPCEAN_HRBS7

    Fonts (Extended Style - Text on top of Barcode)

    CCodeCodeUPCEAN_HRTS1
    CCodeCodeUPCEAN_HRTS2
    CCodeCodeUPCEAN_HRTS3

  • EAN8 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_EAN8(PARAM1)

    PARAM1 - Input Data

    Use the same Function for Extended Style

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_EAN8_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts (Standard Style)

    CCodeCodeUPCEAN_S1
    CCodeCodeUPCEAN_S2
    CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
    CCodeCodeUPCEAN_S4
    CCodeCodeUPCEAN_S5
    CCodeCodeUPCEAN_S6
    CCodeCodeUPCEAN_S7

    Fonts (Extended Style)

    CCodeCodeUPCEAN_HRBS1
    CCodeCodeUPCEAN_HRBS2
    CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
    CCodeCodeUPCEAN_HRBS4
    CCodeCodeUPCEAN_HRBS5
    CCodeCodeUPCEAN_HRBS6
    CCodeCodeUPCEAN_HRBS7

    Fonts (Extended Style - Text on top of Barcode)

    CCodeCodeUPCEAN_HRTS1
    CCodeCodeUPCEAN_HRTS2
    CCodeCodeUPCEAN_HRTS3

  • EXT2 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_EXT2(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_EXT2_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts (Standard Style)

    CCodeCodeUPCEAN_S1
    CCodeCodeUPCEAN_S2
    CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
    CCodeCodeUPCEAN_S4
    CCodeCodeUPCEAN_S5
    CCodeCodeUPCEAN_S6
    CCodeCodeUPCEAN_S7

    Fonts (Extended Style)

    CCodeCodeUPCEAN_HRBS1
    CCodeCodeUPCEAN_HRBS2
    CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
    CCodeCodeUPCEAN_HRBS4
    CCodeCodeUPCEAN_HRBS5
    CCodeCodeUPCEAN_HRBS6
    CCodeCodeUPCEAN_HRBS7

    Fonts (Extended Style - Text on top of Barcode)

    CCodeCodeUPCEAN_HRTS1
    CCodeCodeUPCEAN_HRTS2
    CCodeCodeUPCEAN_HRTS3

  • EXT5 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_EXT5(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_EXT5_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts (Standard Style)

    CCodeCodeUPCEAN_S1
    CCodeCodeUPCEAN_S2
    CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
    CCodeCodeUPCEAN_S4
    CCodeCodeUPCEAN_S5
    CCodeCodeUPCEAN_S6
    CCodeCodeUPCEAN_S7

    Fonts (Extended Style)

    CCodeCodeUPCEAN_HRBS1
    CCodeCodeUPCEAN_HRBS2
    CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
    CCodeCodeUPCEAN_HRBS4
    CCodeCodeUPCEAN_HRBS5
    CCodeCodeUPCEAN_HRBS6
    CCodeCodeUPCEAN_HRBS7

    Fonts (Extended Style - Text on top of Barcode)

    CCodeCodeUPCEAN_HRTS1
    CCodeCodeUPCEAN_HRTS2
    CCodeCodeUPCEAN_HRTS3

  • GS1 Databar 14 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_GS1DATABAR14(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 0 for stand alone. 1 for association with a 2D component.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_GS1DATABAR14_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 0 for stand alone. 1 for association with a 2D component.

    Fonts (Standard Style)

    CCodeCodeGS1D_S1
    CCodeCodeGS1D_S2
    CCodeCodeGS1D_S3 (ConnectCodeCodeGS1D_S3.ttf Default)
    CCodeCodeGS1D_S4
    CCodeCodeGS1D_S5
    CCodeCodeGS1D_S6
    CCodeCodeGS1D_S7

    CCodeCodeGS1DTR (GS1 Databar Truncated)

  • I2of5 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_I2OF5(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_I2OF5_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCodeI2of5_S1
    CCodeCodeI2of5_S2
    CCodeCodeI2of5_S3 (ConnectCodeCodeI2of5_S3.ttf Default)
    CCodeCodeI2of5_S4
    CCodeCodeI2of5_S5
    CCodeCodeI2of5_S6
    CCodeCodeI2of5_S7

    CCodeCodeI2of5_HS3 (embedded Human Readable Text)

  • Industrial 2 of 5 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_INDUSTRIAL2OF5(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_INDUSTRIAL2OF5_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCodeIND2of5_S1
    CCodeCodeIND2of5_S2
    CCodeCodeIND2of5_S3 (ConnectCodeCodeIND2of5_S3.ttf Default)
    CCodeCodeIND2of5_S4
    CCodeCodeIND2of5_S5
    CCodeCodeIND2of5_S6
    CCodeCodeIND2of5_S7

  • ITF14 Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_ITF14(PARAM1, PARAM2, PARAM3)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.
    PARAM3 - 0 for Top/Bottom Bearers Bar. 1 for Rectangle Bearers Bar.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_ITF14_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCodeITF_S1
    CCodeCodeITF_S2
    CCodeCodeITF_S3 (ConnectCodeCodeITF_S3.ttf Default)
    CCodeCodeITF_S4
    CCodeCodeITF_S5
    CCodeCodeITF_S6
    CCodeCodeITF_S7

  • Modified Plessy Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_MODIFIEDPLESSY(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_MODIFIEDPLESSY_HRT(PARAM1, PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 to generate check digit. 0 to turn off check digit.

    Fonts

    CCodeCodeMSI_S1
    CCodeCodeMSI_S2
    CCodeCodeMSI_S3 (ConnectCodeCodeMSI_S3.ttf Default)
    CCodeCodeMSI_S4
    CCodeCodeMSI_S5
    CCodeCodeMSI_S6
    CCodeCodeMSI_S7

  • POSTNET Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_POSTNET(PARAM1)

    PARAM1 - Input Data

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_POSTNET_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts

    CCodeCodePostnet (ConnectCodePostnet.ttf Default)

  • UCCEAN (GS1 128) Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_UCCEAN(PARAM1,PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 for strict GS1 Compliance. 0 for legacy support.

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_UCCEAN_HRT(PARAM1,PARAM2)

    PARAM1 - Input Data
    PARAM2 - 1 for strict GS1 Compliance. 0 for legacy support.

    Fonts

    CCodeCode128_S1
    CCodeCode128_S2
    CCodeCode128_S3 (ConnectCodeCode128_S3.ttf Default)
    CCodeCode128_S4
    CCodeCode128_S5
    CCodeCode128_S6
    CCodeCode128_S7

  • UPCA Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_UPCA(PARAM1,PARAM2)

    PARAM1 - Input Data
    PARAM2 - Extended Style

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_UPCA_HRT(PARAM1,PARAM2)

    PARAM1 - Input Data
    PARAM2 - Extended Style

    Fonts (Standard Style)

    CCodeCodeUPCEAN_S1
    CCodeCodeUPCEAN_S2
    CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
    CCodeCodeUPCEAN_S4
    CCodeCodeUPCEAN_S5
    CCodeCodeUPCEAN_S6
    CCodeCodeUPCEAN_S7

    Fonts (Extended Style)

    CCodeCodeUPCEAN_HRBS1
    CCodeCodeUPCEAN_HRBS2
    CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
    CCodeCodeUPCEAN_HRBS4
    CCodeCodeUPCEAN_HRBS5
    CCodeCodeUPCEAN_HRBS6
    CCodeCodeUPCEAN_HRBS7

    Fonts (Extended Style - Text on top of Barcode)

    CCodeCodeUPCEAN_HRTS1
    CCodeCodeUPCEAN_HRTS2
    CCodeCodeUPCEAN_HRTS3

  • UPCE Barcode

    Custom Function Name

    For Barcode
    =CONNECTCODE.ENCODE_UPCE(PARAM1,PARAM2)

    PARAM1 - Input Data
    PARAM2 - Extended Style

    For Human Readable Text that appears below the barcode
    =CONNECTCODE.ENCODE_UPCE_HRT(PARAM1)

    PARAM1 - Input Data

    Fonts (Standard Style)

    CCodeCodeUPCEAN_S1
    CCodeCodeUPCEAN_S2
    CCodeCodeUPCEAN_S3 (ConnectCodeUPCEAN_S3.ttf Default)
    CCodeCodeUPCEAN_S4
    CCodeCodeUPCEAN_S5
    CCodeCodeUPCEAN_S6
    CCodeCodeUPCEAN_S7

    Fonts (Extended Style)

    CCodeCodeUPCEAN_HRBS1
    CCodeCodeUPCEAN_HRBS2
    CCodeCodeUPCEAN_HRBS3 (ConnectCodeUPCEAN_HRBS3.ttf Default)
    CCodeCodeUPCEAN_HRBS4
    CCodeCodeUPCEAN_HRBS5
    CCodeCodeUPCEAN_HRBS6
    CCodeCodeUPCEAN_HRBS7

    Fonts (Extended Style - Text on top of Barcode)

    CCodeCodeUPCEAN_HRTS1
    CCodeCodeUPCEAN_HRTS2
    CCodeCodeUPCEAN_HRTS3