Forum Discussion
Ed Senatore
Feb 12, 2020Copper Contributor
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...
SergeiBaklan
Feb 12, 2020Diamond Contributor
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.
- Ed SenatoreFeb 14, 2020Copper ContributorThe * before & after the text is required for the Code39 to create the barcode.