Forum Discussion

KevinC2200's avatar
KevinC2200
Copper Contributor
Apr 15, 2020

Using Textjoin/Concat formulas to autofill a cell to create barcodes

Hi,    All hope you are all well and safe.   I am trying to use a formula to convert a sequential number list into barcodes (using installed Free 3 of 9 barcode font in destination cell).  I have...
excel
mathetes's avatar
mathetes
Gold Contributor
Apr 15, 2020

KevinC2200 

 

Your spreadsheet doesn't clearly show what your problem is, nor what you want the result to be.

 

So let me take a stab at what you might be needing in terms of functions. When numbers are involved in Concatenating or TEXTJOIN you need to convert the numbers into text, using the TEXT function.

 

So if you put ="*"&TEXT(A6,"0000")&"*" into your cell B6 it produces *0101* 

If you want *101* you change the second argument in the TEXT function to read "000"  

 

 

  • KevinC2200's avatar
    KevinC2200
    Copper Contributor
    Apr 16, 2020

    mathetes 

     

    That works perfectly, thank you very much for your help.

     

    Regards, 

     

    Kevin

Resources