How to Use Barcode Scanner in Excel (2 Suitable Ways)

Method 1 – Use a Barcode Scanner and Show the Scanned Code in an Excel Cell

Steps:

  • You need to manage a barcode scanner. Turn off the computer and plug in the scanner.
  • Turn on the computer and the scanner.
  • Open the desired Excel file. Point the cursor to the desired place of the sheet. We want to view the scanned date here.
  • Pick the barcode scanner and place it 6 inches away from a barcode, or whatever the recommended distance is.
  • Scan the code with the scanner.
  • The data should be scanned and deposited on the selected cell of the worksheet.

Read More: How to Use Barcode Scanner for Inventory in Excel


Method 2 – Extract Data from Barcodes Created with Excel Code 39 Fonts

Steps:

  • We have the following barcodes for IDs in Column C.

  • We will retrieve the alpha-numeric value from the barcode.
  • Copy barcodes into the Result column.

Extract data from Scanned Barcode Created with Excel Code 39 Fonts

  • Choose all the cells from the Result column.
  • Go to the Font section and choose a font. We chose Calibri.

Extract data from Scanned Barcode Created with Excel Code 39 Fonts

  • Barcodes are converted to alphanumeric values.

Read More: Barcode Scanner Entry to Excel Database with Timestamp


Download the Practice Workbook


Related Articles


<< Go Back to Barcode in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

2 Comments
  1. Hello Alok Paul,
    Thank you for your helpful instruction. I don’t quite understand why mine wouldn’t work. I had the same code as your example, but it wouldn’t work. I cut and pasted your example into my spreadsheet, changed the information, and it worked. I don’t get it but thank you just the same!

    • Hello David Rascati,

      You are most welcome. If you want you can share your code here so that we can debug it to find out the reason.

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo