Forum Discussion
merge information to form a barcode
Hello,
How can I merge the following information to show a barcode in the end cell?
| Code | Date | Carton No. | Weight | |
| 401204 | 02-Feb-23 | 1394 | 17.28 |
The barcode will be the made up as follows:
code (6 digits)/weight (4 digits)/date (reverse 6 digits)/carton No. (6 digits) So the barcode for the above example will be;
4012041728230202001394
Thanks for your help.
Regards
- Yes you can. Use TEXT() function like =A2 & SUBSTITUTE(E2&"",".","") & TEXT(C2,"yymmdd") & "00" & TEXT(D2,"0000")
Thank you very much that worked a treat.... I just discovered that the carton No. is not always 4 digits. it is on rotation from 1-9999...so can I make the D2 a standard 4 digits by leading with 0 when the number is shorter. eg could be carton No. 1 can it show as 0001 or carton 55 can it show as 0055?
- Yes you can. Use TEXT() function like =A2 & SUBSTITUTE(E2&"",".","") & TEXT(C2,"yymmdd") & "00" & TEXT(D2,"0000")
