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 onto a label.
| 3104140020 |
| *3104140020* |
When I use the =A2&" "&B2 I lose the formatting of the Code39 font.
Thank you in advance for any help.
3 Replies
I guess "classic" Code 39 supports only letters and numbers. I'm note familiar with such type of codes, but based on https://www.inflowinventory.com/blog/free-barcode-font-code-39-3-of-9/ Archon Code 39 supports as well other characters like asterisks, you may try with it.
In Excel you can't mix different fonts by formulas, that's only manually or by VBA programming.
- The * before & after the text is required for the Code39 to create the barcode.
- 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
