Apr 15 2020 08:23 AM - edited Apr 15 2020 08:26 AM
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
Apr 15 2020 08:44 AM
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"
Apr 15 2020 11:43 AM
@KevinC2200 Perhaps like in teh attached workbook?
Apr 16 2020 12:01 AM
Apr 16 2020 12:04 AM
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