Barcode suffix & Prefix
 

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

Barcode suffix & Prefix
 

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

--
Happy calculating!

If you like this answer, please click ''Yes.''




"Dimitris" wrote:

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

Barcode suffix & Prefix
 

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

"GSnyder" wrote:

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

--
Happy calculating!

If you like this answer, please click ''Yes.''




"Dimitris" wrote:

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

Barcode suffix & Prefix
 

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

John

"Dimitris" wrote in message ...
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

"GSnyder" wrote:

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

--
Happy calculating!

If you like this answer, please click ''Yes.''




"Dimitris" wrote:

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

Barcode suffix & Prefix
 

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

"jaf" wrote:

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

John

"Dimitris" wrote in message ...
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

"GSnyder" wrote:

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

--
Happy calculating!

If you like this answer, please click ''Yes.''




"Dimitris" wrote:

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