List of ConnectCode's Excel Custom Functions

  • 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