Forum Discussion
Barcode Scanner data entry
Good afternoon, I am attempting to use a Zebra bar-code scanner to use for data entry. I need to separate and remove some information that the scanner adds into the information. the tag will sca...
oh wait, if you know that the part after the "10" is 7 digits long (based on the 2nd formula) then you can use:
=iferror(MID(A2,FIND("P",B2,1),LEN(B2)-8-FIND("P",B2,1)),"")
that said I see line 14 doesn't have a "P". was that a mistake or another problem to deal with?
and if you can't assume "10" is followed by 7 digits then you can use:
=IFERROR(MID(B2,FIND("P",B2,1),FIND("10",B2,FIND("-",B2))-FIND("P",B2,1)),"")
good afternoon all,
=MID(A3,4,FIND("10",A3,FIND("-", A3))-4) is what I have inputted and seems to work with the variations of number combinations that I will be imputing. Thanks to everyone for the help!! I really appreciate it! mtarler wsantos
I will be saving these for other references! I know they will come in handy.