Hello everyone, I just joined and I may have missed this question being answered somewhere in the forum, so please forgive me if it has been duplicated.
I am scanning in a 19 digit number from a barcode and hat I would lie to do I take that text and ten split it into the next 2 cells on the same row. Basically I am splitting the first 8 characters (Item #) and the next 11 characters (serial #).
Here is a brief sample of what the data should look like:
<colgroup><col width="146" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5176;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3128;">
<col width="86" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3072;">
<tbody>
</tbody>
I am scanning in a 19 digit number from a barcode and hat I would lie to do I take that text and ten split it into the next 2 cells on the same row. Basically I am splitting the first 8 characters (Item #) and the next 11 characters (serial #).
Here is a brief sample of what the data should look like:
I can do the split manually, but I would like to do it as soon as I scan the text in from the barcode. Thanks |