Adding a barcode

Copper Contributor

I would like to take text from a cell and add a scannable barcode. Can that be done? Sorry in excel

8 Replies

@dsoracco 

You'll have to install a Barcode Font 

@HansVogelaar 

 

I have done that. What's the next step?

Thanks very much for the help

I got it to work
Thanks for the help!

@dsoracco 

Glad to hear that!

@dsoraccoHow did you get it to work?

@skywatcher1973 

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.

@HansVogelaar 

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 :grimacing_face:

I think it can be a convenient way to streamline processes and track information. Also, I have a helpful resource for your case - the Barcode Finder. Basically, it's a website that offers a comprehensive database and tools related to barcodes. If you have a look through their website, you will see that they have a wide range of barcode types available, and you can generate barcodes from your text or data. It's a user-friendly tool that can assist you in adding the desired barcode to your Excel sheet. Give it a try and see if it meets your requirements.