I have a cell called "Product Code" and I want to use this to generate a barcode in a cell called "Barcode" without using any other cells.
So, the "Barcode" cell would contain the company prefix, product code and the check digit e.g. "5053381" "18220" "4" (final format should be 5053381182204).
The algorithm to generate the check digit is (sum of all odd numbers x3) + (sum of all even numbers) modulo 10, which is "4" for this barcode.
The formula would be something like: 5053381 (concatenate) "Product Code" (concatenate) "check digit algorithm".
Thanks
Bookmarks