Barcode suffix & Prefix

[Dimitris]

Hello there,

I have a question and I need an answer if someone can offer me one. I have
a barcode scanner. If I will try to scan in a cell in excel will take the
barcode number in it and the default enter will move me to the cell under the
first. This is something that I want.
My problem is that my barcode has a prefix (CTRL & F2) and suffix (CTRL &
F2) because I need these prefix & suffix in my ERP. Is there any way when I
scan in excel to bypass these two. Maybe with the function "OnKey" or
something else without changing the barcode reader programming?

Thanks in Advance

Dimitris

 

[GSnyder]

Can you provide an example of what the cell result looks like? I'm trying to
imagine how the CTRL&F2 is coming through...

 

[Dimitris]

The “CTRL & F2 " has been programming on the barcode and it is useful in my
ERP application which it is necessary in order the erp to understand when the
scanning is begging and when it will finish. But in excel the same
combination has different work. If I could say to excel to ignore these
fields before and after the actual barcode I would have a solution to my
problem. Can I say to excel that Enter=" CTRL & F2 " or something else. The
main idea is that when I scan I take: "CTRL & F2" barcode " CTRL & F2" and I
want to keep only the barcode and then pass to the cell under the first..

Thanks a lot

Dimitris

 

[jaf]

Hi Dimitris,
How about a helper column.
One column contains the ctrl&f2 and the other does not.

John

 

[Dimitris]

Dear john,
Unfortsountly it is not going to help. You can see my next post for the
same reason with title "Change default F12"

Thanks

Dimitris

 

[derek054]

Hi, I've done a barcode project before, and as far as I'm concerned, what you demand is not possible. Some barcodes like QR Code might be able to encode a few control characters like tab or carriage return, but I don't think they can be functional.