merge information to form a barcode

[demmettd]

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

[#2]

@demmettd Try the following formula-

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

[#3]

@Harun24HR 

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?

[#4 · Accepted solution]

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

[#5]

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