Barcode data in excel

Lux Aeterna

Board Regular
Joined
Aug 27, 2015
Messages
205
Office Version
  1. 2019
Platform
  1. Windows
Hello everyone!

There are some prescriptions that have barcodes on them. If I scan the barcode, I only get the barcode number. I was wondering if there's a way for to have more data than that, for example the name on the prescription, the DoB etc. Those info are already visible on the paper, but I am not sure if they are included in the barcode.

Thank you in advance.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
When a barcode is scanned it only retrieves its number.
You would need a data base with these codes and the information you want. So when the code is scanned you can search in that base for the rest of the information.
 
Upvote 0
Hello everyone!

There are some prescriptions that have barcodes on them. If I scan the barcode, I only get the barcode number. I was wondering if there's a way for to have more data than that, for example the name on the prescription, the DoB etc. Those info are already visible on the paper, but I am not sure if they are included in the barcode.

Thank you in advance.
As noted by @bferraz, all a barcode is is a long alphanumeric code. There is no other "data" to get. It's very difficult to say what the code means, although a search of the number, or "UPC" and the number might reveal more. One thing for sure, the name of the person prescribed is NOT in the barcode. The barcode would contain the name of the drug, possibly the quantity (mg), possibly an expiration date, and maybe other info on the PRODUCT, but it's just one long alphanumeric code (sometimes just numbers, but can include letters).
I'm not aware of any public database where a UPC code could be retrieved, but again a search might turn one up.
 
Upvote 0
Thank you both of you for your answers!

There is an online database that retrieves that info and I have access to it. But I'm not sure if it's possible to transfer that data to my excel file.

So should I be looking for a way to transfer website data to my excel file?
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top