SOLVED

# merge information to form a barcode

Copper Contributor

# 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

4 Replies

# Re: merge information to form a barcode

@demmettd Try the following formula-

``=A2 & SUBSTITUTE(E2&"",".","") & TEXT(C2,"yymmdd") & "00" & D2``

# Re: merge information to form a barcode

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?

best response confirmed by demmettd (Copper Contributor)
Solution

# Re: merge information to form a barcode

Yes you can. Use TEXT() function like =A2 & SUBSTITUTE(E2&"",".","") & TEXT(C2,"yymmdd") & "00" & TEXT(D2,"0000")

# Re: merge information to form a barcode

you are an absolute legend....thank you so much for your help.
1 best response

Accepted Solutions
best response confirmed by demmettd (Copper Contributor)
Solution

# Re: merge information to form a barcode

Yes you can. Use TEXT() function like =A2 & SUBSTITUTE(E2&"",".","") & TEXT(C2,"yymmdd") & "00" & TEXT(D2,"0000")