Forum Discussion
Looking to combine alpha/numeric & barcode in the same cell
I have a spreadsheet with date in one column that consists of alpha/numeric and another column with Code39 barcode font. I need to combine them into one cell with one over the other in order to print...
Assuming you have 23/12/2019 in cell A1 and Code39 in cell B1.
In cell C1, execute the formula: TEXT(A1,"DD/MM/YYYY")&"-"&B1
When you click Enter, you will have this result 23/12/2019-Code39.
Kindly let me know of that's what you need
In cell C1, execute the formula: TEXT(A1,"DD/MM/YYYY")&"-"&B1
When you click Enter, you will have this result 23/12/2019-Code39.
Kindly let me know of that's what you need