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.

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

• Barcodes are converted to alphanumeric values.

Read More: Barcode Scanner Entry to Excel Database with Timestamp

Download the Practice Workbook

Related Articles

• How to Move Barcode Scanner to Next Row in Excel
• How to Make Auto Enter with Barcode Scanner in Excel
• Creating Barcode Scanner to Track Check in & Check out Time in Excel
• [Solved] Barcode Scanner Not Going to Next Line in Excel
• Creating a Barcode Scanner Macro in Excel

<< Go Back to Barcode in Excel | Learn Excel