#### pharmavenger

##### New Member

- Joined
- Jul 19, 2019

- Messages
- 7

I'm a pharmacy student working on how to extract numbers from medication QR codes into individualized columns in Excel.

For example, this code

010030093552606517201130101040951182110091947809740 needs to put into 3 columns: GTIN, Lot, and Expiry date. GTIN is donated by 01 in front and has a 14 fixed digit. Lot number is denoted by 10 and the digits may vary (its not fixed so that is why we were having trouble). Expiry date is denoted by 17 and its fixed at 6 digits. I have tried the following code: =LEFT(MID(A1,SEARCH("17",A1)+2,LEN(A1)),FIND("21"-1,MID(A1,SEARCH("17",A1)+2,LEN(A1)))-1) |

<tbody>

</tbody>

This is an screenshot of what I'm working towards: https://paste.pics/0d7ee6a250f7a17721281285a2985621

This is more information on the code: https://paste.pics/7622d1f5f0708387defb889dab03198b

Any advice is helpful. Thank you!!!