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 tried using both CONCAT and TEXTJOIN  functions without success and continually get an error message.  The  format is as  per attached, follows:

 

Any help would be hugely appreciated.

 

Thanks & Regards, 

 

 

Kevin

excel

4 Replies

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

      Riny_van_Eekelen 

       

      Hi Riny, thanks for the information, unfortunately when you change  number (e.g. A6)  I get a #name? message, Mathete's solution worked perfectly.

       

      Thank you once again for your help

       

      Regards, 

       

       

      Kevin

  • 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"  

     

     

Resources