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...
maybe it was a cut and paste error but this formula isn't correct:
=MID(A2,FIND("P",A2,1),FIND(10,A2)-FIND("P"A2,))
maybe try:
=MID(A2,FIND("P",A2,1),FIND("10",A2)-FIND("P",A2,1))
btw, if you know it will always scan in starting as 240P then why not replace all the FIND("P"... with a fix number?
Hi Matt,
That worked partially, but it is still not giving the response that I am looking for. I have attached the spreadsheet with test data. I am not sure if I can do fixed number because the information varies so much. Do you have any thoughts on improving?