extracting a small piece of bar code with scanner and input into excel

[xxdocxx]

Hello folks,

I have just got a project dumped in my lap and I need help ASAP. I have a Kercan scanner and I need to scan a specific bar code that has 80 characters. I need to only extract characters 35 - 39, they are the quantity of the item. I have looked and cannot find any help on this.


Any ideas?


Doc

 

[Weazel]

if its that straightforward then maybe...

=MID(A1,35,5)

 

[xxdocxx]

if its that straightforward then maybe...

=MID(A1,35,5)

Thank you. Worked like a charm.