Forum Discussion

Copper Contributor

Feb 23, 2023

Solved

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 ...

excel

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

Harun24HR

Bronze Contributor

Feb 24, 2023

demmettd Try the following formula-

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

demmettd
Copper Contributor
Feb 24, 2023
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?
- Harun24HR
  Bronze Contributor
  Feb 24, 2023
  Yes you can. Use TEXT() function like =A2 & SUBSTITUTE(E2&"",".","") & TEXT(C2,"yymmdd") & "00" & TEXT(D2,"0000")
  - demmettd
    Copper Contributor
    Feb 24, 2023
    you are an absolute legend....thank you so much for your help.