Forum Discussion
dsoracco
Mar 10, 2022Copper Contributor
Adding a barcode
I would like to take text from a cell and add a scannable barcode. Can that be done? Sorry in excel
skywatcher1973
Feb 06, 2023Copper Contributor
dsoraccoHow did you get it to work?
HansVogelaar
Feb 06, 2023MVP
Let's say you enter the letters/digits you want to convert to barcode in A2 and down.
Enter the formula ="*"&A2&"*" in B2.
Set the font of B2 to the barcode font that you downloaded and installed.
Fill down from B2.
- skywatcher1973Feb 07, 2023Copper Contributor
Thanks I figured out it was a glitch in the spreadsheet. I deleted that sheet & started over, worked perfectly.
Now to figure out how to build the rest of the spreadsheet 😬