List of Barcode Formulas

The Barcode Formulas support parameters for turning on the generation a check digit or human readable , and will automatically convert the data string into a barcode string. The table below provides the entire list of these formulas/macros/functions. All these functions can be used in Excel, Word, Access and Crystal Reports.

Function Name Parameters Description
Encode_Code39 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Code 39 barcode. Invalid characters from the input will be automatically removed.
Encode_Code39ASCII Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Code 39 ASCII barcode. Invalid characters from the input will be automatically removed.
Encode_EAN8 Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for EAN 8 barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_EAN13 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Encode with Human Readable Text, 0 Otherwise
Returns the encoded barcode string for EAN 13 barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_EXT2 Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for UPC Extension 2 barcode. Invalid characters from the input will be automatically removed.
Encode_EXT5 Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for UPC Extension 5 barcode. Invalid characters from the input will be automatically removed.
Encode_UPCA Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Encode with Human Readable Text, 0 Otherwise
Returns the encoded barcode string for UPCA barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_UPCE Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Encode with Human Readable Text, 0 Otherwise
Returns the encoded barcode string for UPCE barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_UCCEAN Param 1 - String value to be encoded as a barcode

Sample Input - (00)123456789012345675(12)1A
Returns the encoded barcode string for UCCEAN barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128Auto Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128 Auto barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128A Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128A barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128B Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128B barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_Code128C Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Code128C barcode. Invalid characters from the input will be automatically removed. Check Digit is compulsory.
Encode_I2of5 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for I2of5 (Interleaved 2 of 5) barcode. Invalid characters from the input will be automatically removed.
Encode_ITF14 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Param 3 - Integer value 0 to generate Top/Bottom Bearers Bar and 1 to generate Rectangle Bearers Bar.
Returns the encoded barcode string for ITF14 barcode. Invalid characters from the input will be automatically removed.
Encode_Industrial2of5 Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Industrial 2of5 barcode. Invalid characters from the input will be automatically removed.
Encode_ModifiedPlessy Param 1 - String value to be encoded as a barcode
Param 2 - Integer value 1 to Generate a Check Digit, 0 for otherwise
Returns the encoded barcode string for Modified Plessy barcode. Invalid characters from the input will be automatically removed.
Encode_CodeCodabar Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for Codabar barcode. Invalid characters from the input will be automatically removed.
Encode_POSTNET Param 1 - String value to be encoded as a barcode
Returns the encoded barcode string for POSTNET barcode. Invalid characters from the input will be automatically removed.