How to insert special character TAB in a barcode using font "free 3 of 9" ?

**HUHA** · 03-01-2021, 07:57 PM

Hello.
I am using font 3 of 9 to generate barcodes, print them and scan them with a handheld USB scanner model LS2208 .

The text that i wish to print is something like this

1234567890TAB12345678901234TABTAB

How can i make it when i scann the barcode, that instead of reading the letters T A B to make it like i press key TAB from the keyboard ?
And i have to enable on the scanner something ?
Thank you.

**Sam Capricci** · 03-01-2021, 08:23 PM

In XL if you press the tab key and you’re in one cell it will simply move you to the next cell, so if you are in cell A1 and you press tab you will simply move to sell B1 is that what you want?

Otherwise I would look into using the substitute formula.

**Sam Capricci** · 03-01-2021, 08:27 PM

Oh, depending on how you want it to look you might also consider find and replace.

**Sam Capricci** · 03-01-2021, 10:13 PM

BTW, if you’d like more and better help, check the yellow banner at the top of the post and upload a sample workbook with representative samples AND desired results.

**HUHA** · 03-02-2021, 04:53 AM

Hello.

I need that the excel to generate a barcode with numbers and letters , which includes TAB to jump to the next row in a software.

I have a software with 3 rows and when i am scanning the barcode, i need to fill the first row with letters (around 9-10 characters),

after it will automatically go to the 2nd row which i want to be empty and jump to the next row with TAB,

and the cursor will reach 3-rd row. Here i need to enter a car number (around 7-8 number and letters ) and after the data ends, i need to go back to 2-nd row , these means one TAB to go to first row and again another TAB to go to 2-nd row , and here the user will input something manually .

the barcode that i scanned will not be scanned in excel.

Thank you.